Forum Discussion
Can I change the values in multiple rows
I have 15 thousand rows and I have to number them sequentially 1,2,3,4,5 every time the value in row A changes Explanation; If the value in cells A1-5 are all 12345 and I want to convert all of ...
Enter the following formula in B1:
=COUNTA(UNIQUE(A$1:A1))
and fill down to the last used row. If you want to replace the values in column A, copy column B and paste as values, then delete column A.
HansVogelaar thank you so much!