LinkBack URL
About LinkBacks
i have example from attachments. i want to put the race bib number in D2 for the 1rst winner and the name will follow as 1rst in D2:B2, 2nd in D3:B3, 3rd in D4:B4 and so on. and i have 100 runners.
thank you for helping..
i have example from attachments. i want to put the race bib number in D2 for the 1rst winner and the name will follow as 1rst in D2:B2, 2nd in D3:B3, 3rd in D4:B4 and so on. and i have 100 runners.
thank you for helping..
Hi mmanuel99,
Welcome to the forum.
If I enter a bib number.. let say 500 in D2, what should be the result? can you share the scenario?
Since you want the entry in column D.. then how come 1st winner will appear in D2:B2.. either it should be C2:A2 or something else which I am not getting
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
do you mean something like this? see attached
or alternatively just sort by col c ascending and put
in column dFormula:
Please Login or Register to view this content.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
sorry for wrong explanaton...
the first person to finish line is bib number 408.
now i want to input that bib number in D2 and she will be the rank number 1
name will shown in D2.
the second person to finish line is bib number 502.
now i want to input that bib number in D3 and he will be the rank number 2
name will shown in D3.
the third person to finish line is bib number 455.
now i want to input that bib number in D4 and she will be the rank number 3
name will shown in D4.
and the rest will follow as rank numer 4,5,6,7 and so on until the race is finish
thak you for your help i really appreciate...
well according to your sheet
502 ally 00:00:25.38
is the fastest time
look at the attachment again i've reattached it and made a few changes
Last edited by martindwilson; 12-16-2012 at 05:57 AM.
martindwilson....thank you very much this exactly what i want god bless you...
Last edited by mmanuel99; 12-18-2012 at 11:54 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks