Hello! I'm trying to figure out a formula how to add running numbers for values and then compare them in my spreadsheet.
Here's a sample what I'm after:
I'm looking for the formula for the last column. Numbers in brackets are just for a hint. I know you can sort columns by highest/lowest value and then use ROW function but that would add 2 extra columns I don't want. Also same values should have the same running number (1st, 1st, 3rd, 4th...), but that's not mandatory.Please Login or Register to view this content.
Bookmarks