NAME AMOUNT
MAX 20
CLIFF 5
CLIFF 38
MAX 40
CLIFF 60
DOT 50
CLIFF 60
CLIFF 60
CLIFF 78
CLIFF 60
DOT 44
I have a data table with names and scores. Sometimes the names are repeated.
Cliff is repeated 4 times. Does anyone knows a formula that will tell me that
Cliff's lowest score is 5 and his second to lowest score is 38? 60 would be
his 3rd lowest and 78 would be his 4th. I tried using small, but small
indicates that 60 is the 3rd , 4th and 5th lowest with 78 being the 6th .
In reality, 78 is not his 6th lowest but his 3rd.