Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sort a table in excel
as you can see below i have a table ive created for a website im working on
for a football team.. how would i script it to where when i started entering in win's and loss's the team with the best record would automatically be sorted at the top... the win's range is column " c "... trey Standing's Atlantic Division ( Bold notate's a Home Game ) Eastern Division WON LOST % PF PA Danbury Brigadier's 8 6 0.571428 571 594 552 Fayetteville Guard 7 7 0.5 620 527 Greensboro Revltn 8 6 0.571428 571 594 552 Tennessee Rivshrks 7 7 0.5 620 527 Mass. 8 6 0.571428 571 594 552 ( Click here for full NIFL Team Standings ) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sort a table in excel
To do a sort, simply use the DataSort command. Make sure the active cell is in
the table you want to sort. It will help if you use a header row to identify the columns. Then sort by column C (presumably in descending order as you want the highest number of wins on top). BTW plurals in English do not have an apostrophe, as in: Standings, wins, losses, Brigadiers (and notates). -- Regards, Fred "trey braid" wrote in message ... as you can see below i have a table ive created for a website im working on for a football team.. how would i script it to where when i started entering in win's and loss's the team with the best record would automatically be sorted at the top... the win's range is column " c "... trey Standing's Atlantic Division ( Bold notate's a Home Game ) Eastern Division WON LOST % PF PA Danbury Brigadier's 8 6 0.571428 571 594 552 Fayetteville Guard 7 7 0.5 620 527 Greensboro Revltn 8 6 0.571428 571 594 552 Tennessee Rivshrks 7 7 0.5 620 527 Mass. 8 6 0.571428 571 594 552 ( Click here for full NIFL Team Standings ) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sort a table in excel
bear with me here... how i do the sort and have the accompany columns sort
with column c ? ? ? column a is the team column d are the losses column e % of win's losses column f points for column g points against the header is teams - wins - losses - % - points for - points against "Fred Smith" wrote: To do a sort, simply use the DataSort command. Make sure the active cell is in the table you want to sort. It will help if you use a header row to identify the columns. Then sort by column C (presumably in descending order as you want the highest number of wins on top). BTW plurals in English do not have an apostrophe, as in: Standings, wins, losses, Brigadiers (and notates). -- Regards, Fred "trey braid" wrote in message ... as you can see below i have a table ive created for a website im working on for a football team.. how would i script it to where when i started entering in win's and loss's the team with the best record would automatically be sorted at the top... the win's range is column " c "... trey Standing's Atlantic Division ( Bold notate's a Home Game ) Eastern Division WON LOST % PF PA Danbury Brigadier's 8 6 0.571428 571 594 552 Fayetteville Guard 7 7 0.5 620 527 Greensboro Revltn 8 6 0.571428 571 594 552 Tennessee Rivshrks 7 7 0.5 620 527 Mass. 8 6 0.571428 571 594 552 ( Click here for full NIFL Team Standings ) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sort a table in excel
Highlight one of the cells in your table. Then choose DataSort...
Excel will automatically highlight all of the adjacent cells. This is the table it will sort. Excel will move the whole row when it sorts on column c, so the cells in the row will stay together. If your table has blank cells in it, Excel may not choose exactly what you want. In this case, highlight the whole table before you execute DataSort... -- Regards, Fred "trey braid" wrote in message ... bear with me here... how i do the sort and have the accompany columns sort with column c ? ? ? column a is the team column d are the losses column e % of win's losses column f points for column g points against the header is teams - wins - losses - % - points for - points against "Fred Smith" wrote: To do a sort, simply use the DataSort command. Make sure the active cell is in the table you want to sort. It will help if you use a header row to identify the columns. Then sort by column C (presumably in descending order as you want the highest number of wins on top). BTW plurals in English do not have an apostrophe, as in: Standings, wins, losses, Brigadiers (and notates). -- Regards, Fred "trey braid" wrote in message ... as you can see below i have a table ive created for a website im working on for a football team.. how would i script it to where when i started entering in win's and loss's the team with the best record would automatically be sorted at the top... the win's range is column " c "... trey Standing's Atlantic Division ( Bold notate's a Home Game ) Eastern Division WON LOST % PF PA Danbury Brigadier's 8 6 0.571428 571 594 552 Fayetteville Guard 7 7 0.5 620 527 Greensboro Revltn 8 6 0.571428 571 594 552 Tennessee Rivshrks 7 7 0.5 620 527 Mass. 8 6 0.571428 571 594 552 ( Click here for full NIFL Team Standings ) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sort a table in excel
i get an error " this operation require's merged cells to be identicallyt
sized " and i have none... ???? "Fred Smith" wrote: Highlight one of the cells in your table. Then choose DataSort... Excel will automatically highlight all of the adjacent cells. This is the table it will sort. Excel will move the whole row when it sorts on column c, so the cells in the row will stay together. If your table has blank cells in it, Excel may not choose exactly what you want. In this case, highlight the whole table before you execute DataSort... -- Regards, Fred "trey braid" wrote in message ... bear with me here... how i do the sort and have the accompany columns sort with column c ? ? ? column a is the team column d are the losses column e % of win's losses column f points for column g points against the header is teams - wins - losses - % - points for - points against "Fred Smith" wrote: To do a sort, simply use the DataSort command. Make sure the active cell is in the table you want to sort. It will help if you use a header row to identify the columns. Then sort by column C (presumably in descending order as you want the highest number of wins on top). BTW plurals in English do not have an apostrophe, as in: Standings, wins, losses, Brigadiers (and notates). -- Regards, Fred "trey braid" wrote in message ... as you can see below i have a table ive created for a website im working on for a football team.. how would i script it to where when i started entering in win's and loss's the team with the best record would automatically be sorted at the top... the win's range is column " c "... trey Standing's Atlantic Division ( Bold notate's a Home Game ) Eastern Division WON LOST % PF PA Danbury Brigadier's 8 6 0.571428 571 594 552 Fayetteville Guard 7 7 0.5 620 527 Greensboro Revltn 8 6 0.571428 571 594 552 Tennessee Rivshrks 7 7 0.5 620 527 Mass. 8 6 0.571428 571 594 552 ( Click here for full NIFL Team Standings ) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sort a table in excel
i got it to work...thanks for the head's up...
"Fred Smith" wrote: Highlight one of the cells in your table. Then choose DataSort... Excel will automatically highlight all of the adjacent cells. This is the table it will sort. Excel will move the whole row when it sorts on column c, so the cells in the row will stay together. If your table has blank cells in it, Excel may not choose exactly what you want. In this case, highlight the whole table before you execute DataSort... -- Regards, Fred "trey braid" wrote in message ... bear with me here... how i do the sort and have the accompany columns sort with column c ? ? ? column a is the team column d are the losses column e % of win's losses column f points for column g points against the header is teams - wins - losses - % - points for - points against "Fred Smith" wrote: To do a sort, simply use the DataSort command. Make sure the active cell is in the table you want to sort. It will help if you use a header row to identify the columns. Then sort by column C (presumably in descending order as you want the highest number of wins on top). BTW plurals in English do not have an apostrophe, as in: Standings, wins, losses, Brigadiers (and notates). -- Regards, Fred "trey braid" wrote in message ... as you can see below i have a table ive created for a website im working on for a football team.. how would i script it to where when i started entering in win's and loss's the team with the best record would automatically be sorted at the top... the win's range is column " c "... trey Standing's Atlantic Division ( Bold notate's a Home Game ) Eastern Division WON LOST % PF PA Danbury Brigadier's 8 6 0.571428 571 594 552 Fayetteville Guard 7 7 0.5 620 527 Greensboro Revltn 8 6 0.571428 571 594 552 Tennessee Rivshrks 7 7 0.5 620 527 Mass. 8 6 0.571428 571 594 552 ( Click here for full NIFL Team Standings ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table report discarded in Excel 2003 - any fix available? | Excel Discussion (Misc queries) | |||
Can I copy a table from Word into one cell in Excel without losing data? (Office 97) | Excel Discussion (Misc queries) | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Excel Sort should prompt headers before fields; selections erase. | Charts and Charting in Excel | |||
Pivot Table Security in Excel | Excel Discussion (Misc queries) |