PDA

View Full Version : Ranking and declaring winner and runner up



gary2014
11-11-2014, 07:30 AM
1249712497

Hi team,

I would like to determine only "Winner" & and "Runner Up" from a points table.

I have attached file for your reference.

Please help!!!

Aussiebear
11-11-2014, 01:59 PM
Create a helper column in Column I, then starting at cell I5 enter the following formula and drag down =Rank(H5,$H$5:$H$9,1). As the points compile throughout the season the relative placings will change.

gary2014
11-11-2014, 05:23 PM
Hi,

Thank you for kind reply.