Hello-

I have header info in row 1, and want to add a "record number" in column A. I want the number in column A to increment based on value in column J, but duplicate itself if duplicates are found in J. This is the last step to the spreadsheet, all other formating and sorting has been done to this point.

column A column J
1 15326
2 85632
3 25415
3 25415
3 25415
4 65268
5 45874

Any help is greatly appreciated

Thanks

Scott