Can I change the values in multiple rows

New Contributor

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?

 

 

2 Replies

@RK8257 

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.

@Hans Vogelaar thank you so much!