Way to display all changes to data in a column in Excel

[CylenaColeman]

Looking to find a way to show when data changes in a column.
Ex: 23.00, 23.00, 45.00, 45.00, 45.00, 60.00, 60.00, 60.00, 70.00
With the above, there are4 changes that I would want to display, the 23.00, the 45.00, the 60.00 and the 70.00
How would you do this in Excel?

[Richard Buttrey]

Hi and welcome to the forum.

One way would be with a conditional format.
With the data in say A1:A10 then create a CF for A1

Please Login or Register  to view this content.

and apply it to the whole range A1:A10

[Logit]

.
This is probably more than you are seeking but it is another approach for all changes :

Please Login or Register  to view this content.

Your workbook must have a sheet named Tracker.

The macro code is pasted in the ThisWorkbook module so it can track all sheets in the workbook.