Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to sort a column of data which is the SUM of three cols
I want to sort a TOTAL coulmn which includes the value of the function SUM of
three other coulmns. The column represents a ranking of players. I want to sort the entire file based on that column. How can I do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to sort a column of data which is the SUM of three cols
Select the area you want to sort. Click on Data, Sort, and select the column
you want to sort on to sort by? -- HTH Kassie Replace xxx with hotmail "freebird" wrote: I want to sort a TOTAL coulmn which includes the value of the function SUM of three other coulmns. The column represents a ranking of players. I want to sort the entire file based on that column. How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
2 Cols To 2 Cols VLookup Comparison | Excel Discussion (Misc queries) | |||
If 2 cols meet a criteria then sum the 3rd column | Excel Worksheet Functions | |||
Cond Format:re color 2 cols, skip 2 cols | Excel Worksheet Functions | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) |