if names in a2:a7
C2=LARGE($B$2:$B$7,ROW()-1)
D2=INDEX($A$2:$A$7,MATCH(C2,$B$2:$B$7,0))
E2=14 E3=9 E4=8 E5=7 E6=? E7=?
F2=C2+E2
insert all formulas and copy down to row 7
"phat al" skrev:
I have a list of six people who total different scores every day.
I need to add the data to a chart based on who is on top and so forth.
Currently I add there totals and then sort by highest to lowest in
excel.
Than I manually add it to a data sheet.
Is there a way to add it constantly and have an auto update that finds
the top and seconds and so forth.
Eg
Jim 100
Bob 4500
Sue 3000
Tom 3500
Will look like this after
Bob 4500
Tom 3500
Sue 3000
Jim 100
First place gets 14 points to main score, second gets 9 points, third
gets 8 and Jim gets 7
So main board looks like this
Jim 7
Bob 14
Sue 8
Tom 9
--
phat al
------------------------------------------------------------------------
phat al's Profile: http://www.excelforum.com/member.php...o&userid=34988
View this thread: http://www.excelforum.com/showthread...hreadid=567672