Hello everyone,
V Points for rank
9 0
4 1
8 0
I would like to award a single point (integer 1) for the lowest value in a set. I have used:
=LOOKUP(RANK(B$3,B$3:B$5),{1,2,3},{0,0,1})
However, this fails if there is a tie for the lowest value. In that instance all values receive a "0." What is the simplest way to resolve this problem. My guess is a COUNTIF solution, I'm just not sure what it is.
Greatest thanks
Bookmarks