Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
list names in random order in Excel 2002 | Excel Discussion (Misc queries) | |||
How may I make a list display in alphabetical order in Excel? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
List rows in an order based on a cells value | Excel Discussion (Misc queries) | |||
list of all excel 2000functions | Excel Discussion (Misc queries) |