Rank In Excel

M

miter55

Joined
Apr 18, 2006
Messages
2
Reaction score
0
How do I set up a formula to rank cells where it will rank in numeric succession even in the event there is a "tie".

For Example...
The Second example in the attachment is the way I would like it to rank.

The first example in the attachment is how it is ranking now, and i'm having trouble writing a formula to have it show the first example


ANY assistance is appreciated !
 

Attachments

Ranking

Hi miter55

Don't know if you can transpose the results and rankings vertically - but if you can and also sort the results desending the following formula will work (assume you have the first result in cell A2 with a header in A1 (Results). In cell B2 enter =IF(A2=A1,B1,N(B1)+1)

See SS in attached ranking-2-zip

Regards

Zoddy
 

Attachments

You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ranking without skipping ranks and percentile 3
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Not ranking 0's 2
rank scores show ties and add top four scores 3
Ranking Duplicate Numbers 2
Rank In Excel 0
Rank Formula 1
ranking cells in excel 2

Back
Top