Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking
I was trying... =Rank(c22,c22,c23,0) which I knew was wrong.
I think I've figured it out though, not sure why it took me asking here to have it come to me :0) This formula seems to work... =Rank(c22,(2cc,c23),0) Thank you anyways. "Teethless mama" wrote: Post your formula. "casdaq" wrote: I'm sure there is such an easy answer to this but I can't for the life of me right now figure it out... I have two results in column C, 80% in row 22 and 90% in row 32. In column D 22 & 32 I need to rank these two and I want to set up a formula to do so as it will be used on a monthly basis. What formula can I use to rank these two numbers? I've tried the normal ranking formula and it doesn't seem to work what how I am trying it when skipping cells. I would think the IF formula would work but I'm not too familiar with it and cannot seem to find the calculation that works. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ranking | Excel Discussion (Misc queries) | |||
Ranking? | Excel Discussion (Misc queries) | |||
Ranking | Excel Worksheet Functions | |||
ranking | Excel Worksheet Functions | |||
Ranking | Excel Discussion (Misc queries) |