If the data changes, how to show only the changed data?

Question

excel

Hey!

In my excel, the data in the cell (A6) changes periodically (every 5 or 1 min).
excel file

Tell me how to display in a separate cell, the name in the event that the new updated data does not equal the previous value in the same cell?

My problem is to compare new and old data, as long as they are in the same cell and are constantly updated.

Answer 1

Direction: a macro that will write each new value of this cell to a different location, for example, columns A and B on the "ChangesA6" sheet:

Значение  Время
0,10      01.01.2022 16:49
0,11      01.01.2022 16:53