Hi guys,
I tried to rank a number of values and it worked with sumproduct. The problem is that some rows contain no value (or errors), so I wanted to rank only those with values.
A B Rank
1 Pepe 1 1
2 Pepe 2 2
3 Pepe N/A None
Please help.
Thanks!
Bookmarks