Function for rankings

  • Thread starter Thread starter Rahul
  • Start date Start date
R

Rahul

I am trying to create a spreadsheet where a ranking
system can be inserted and updated.

I have one worksheet where people are ranked. mark 1,
paul 2, etc and goes down like that.
The next worksheet has a list of "sections" where people
would go in ranking order. However, not everyone on the
ranking page will be on the sections sheet. I want to be
able to put someone like Paul on the sections sheet and
he will be placed in ranking order. for example i have
paul 2, jim 4, suzy 7. I want the sections sheet to put
them in ranking order. How can i do this? The ranking
worksheet has one cell for the name and a seperate cell
for the ranking order.

thanx!
 
Hi Rahul,

Assuming that Column A contains names, Column B contains their ranking,
and the data starts in Row 2...

D1:

=MAX(B:B)

E2, copied to the next column and down:

=IF(ROW()-ROW(E$2)+1<=$D$1,INDEX(A$2:A$100,MATCH(ROW()-ROW(E$2)+1,$B$2:$B
$10,0)),"")

This will give you a listing of all the rankings. If, for example, you
want a list of the top 5, then enter the number 5 in D1 and you'll
automatically get a top 5 list.

Hope this helps!
 
First of all thank you! that function was close

here's what i want:
I uploaded a sample of my workbook.
http://www.poorreflection.com/Rahul/ranking.xls
it's just to figure out what to do then i will format it.

Rankings are automatically entered at the beginning of
the month. I want the "17 chart" sheet to automatically
read the rankings from the rankings sheet and put the
names in descending order (by rank basically) on
the "people on shift" sheet. Then i want the "17 chart"
sheet to pull from the "people on shift" sheet and
arrange them in the according stations automatically. so
everything on the "17 chart" should be automated so the
user can not change anything. Does that make sense? thanx
for your help!
please let me know what you think would be the best way
to do this.
 
I hate to do this to you but, if you have time, could you
explain the function you sent? I would love to know how
to do this in the future. I tried to figure it out, but
was stumped
thanx!
 
Back
Top