positions

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

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
 
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?
 
Hi Tom!

Nice to read your reply. I looking for best score (in column2-SCORE) of
1 (column1-Name) and separate best score of 0 and give him appropriate
place in column3-POSITION
I present clear exapmle below:

NAME SCORE POSITION (which function ?)
1 49 2
1 50 1
1 48 3
0 48 3
0 49 2
0 50 1

I hope, you understand my problem.

Many thanks in anticipation.
Regards
Mark
 
Back
Top