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?

--
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

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!