Sep 21 2022 06:29 AM
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 them to a value of 1 and the value in cells A6-9 are 87654 and I want those to be a value of 2 , then the value in A10-18 = 16879756 and I want those values to be 3. how do I do it?
Sep 21 2022 06:33 AM
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.
Sep 21 2022 06:34 AM
@Hans Vogelaar thank you so much!