LinkBack URL
About LinkBacks
I have a column of different "finish" times (hh:mm:ss). I would like to have the adjacent column look at all of the "finish times" and post their ranking from 1st place to last.
Comparing times & sorting
I have a column of different "finish" times (hh:mm:ss). I would like to have the adjacent column look at all of the "finish times" and post their ranking from 1st place to last.
Last edited by snapajap; 08-13-2009 at 02:01 PM.
With times in C2:C9, put this rank formula in D2 and copy down:
=RANK(C2,$C$2:$C$9,1)
...change the 1 at the end to a zero if you want to reverse the rankings.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Wow, that was a fast and accurate reply, thanks!
The one problem is.....I have the 38 row spreadsheet all formulated, sometimes I'll have 3 contestants and sometimes 33. The formula you posted looks at the whole sheet and ranks to the last row even if I haven't entered in data.
I have chosen the option not to display zeros, so while the sheet is blank in the non used rows I guess the formula still looks at them??
Make any sense at all, felt I was babbling!
Thanks again!
Never mind, I shook off some cobwebs and came up with this...
=IF(B5>0,RANK(J5,$J$5:$J$7,1),"")
Thanks for your help!
Let's see your sheet. Click GO ADVANCED and use the paperclip icon to post up your workbook.
=====EDIT:
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
I think it uploaded, however, I discovered it does not work the way I did it. I am an idiot!
Change your J5 formula to:
=IF(H5,C5+H5,"")
..and copy down.
Now your K5 formula will work properly.
Brilliant!
Thanks a million.
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
It says I can't leave anymore rep. for you until I spread some around to other users.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks