Can Excel list order according to Total scores?
 

I'm sorry but I am real newbie to Excel, I'm running a Sweet 16 pool at work
and wondered if I could use Excel to make a interactive score list? What I
want to do is list the players names in column A 1st , 2nd, 3rd and final
round totals in columns C, D, E and F and then have column G as the total of
each round score, the main thing I need is to have the list go in order from
high to low according to the scores I enter in Column G.. I hope that makes
sense lol..

Can Excel list order according to Total scores?
 

Set up your sheet as described, making sure your top row is a header of
column descriptors and that you have no blank columns or rows in your
grid. Place your cursor in the top left cell (A1?) and from the main
menu, choose DataFilterAutoFilter

There will appear dropdown arrows in each header cell. Click the one
in col. G and choose Sort Ascending.

Done!

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=526213

Can Excel list order according to Total scores?
 

Thanks Bruce, worked great...



"swatsp0p" wrote in
message ...

Set up your sheet as described, making sure your top row is a header of
column descriptors and that you have no blank columns or rows in your
grid. Place your cursor in the top left cell (A1?) and from the main
menu, choose DataFilterAutoFilter

There will appear dropdown arrows in each header cell. Click the one
in col. G and choose Sort Ascending.

Done!

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=526213