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:
Item#3 7 (2.) 45 (4.) -2
Item#1 5 (3.) 32 (1.) +2
Item#5 8 (1.) 47 (5.) -4
Item#4 3 (5.) 42 (2.) +3
Item#2 5 (3./4.) 44 (3.) 0/+1
...
Item#n x (n.) x (n.) +/-n
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.
Bookmarks