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?