I have a row of values in D3:K3 want to work out which is ranked 1st, 2nd, 3rd etc?
I can not work out how to use RANK as I am putting 1st place in L3, 2nd place in M3, 3rd place in N3. I have looked into Array formula's but just can't quite make it work.
Bookmarks