I want column A to number my rows, but have that number refresh when sorting for the data in column B. Anyone able to follow that? I want the numbers to be 1 through whatever when the data is unsorted, numbering all rows that are shown, but when I sort to compress the sheet and only show the set from column B or column D or whatever that I want, I don’t want column A to still show 4, 17, 53, etc. I want it to go back to 1 through whatever, so I can see the total number for that data set. Does that make sense?