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



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


Enter the following formula in B1:




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!