positions
Sounds like you want a conditional rank function. How do you want to treat
tied scores - would they be equal rank and then skip ranks the same way Rank
does, or what?
--
Regards,
Tom Ogilvy
"Mark" wrote in message
...
Hi all,
Is there any function or script who counting position in
column 3.
Function = best points (column 2) of Name (column 1)
e.g.:
NAME result position ?? (best result of 0 and 1)
1 50 1
1 36 4
0 46 1
0 45 2
1 38 2
1 31 5
1 37 3
0 26 3
Column 3 i calculate manually.. I looking for function.
I'd like avoid any sorting and save current position of
records.
TIA
Mark
|