| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to sort data that is the result of a sum function
I am trying to sort 2 columns, the first being alpha names and the second
being values that are determined by sum functions. When I sort, the alphas sort as expected but the sum function cells do not, and therefore the data is no longer properly aligned. How can I sort the alpha and sum function cells together? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to sort data that is the result of a sum function
Select both columns prior to sort operation. Also, if the value
returned by the sum functions changes due to sorting, you may get incorrect results. Provide more information on your exact data structure. On Nov 20, 4:36 pm, BCClocks wrote: I am trying to sort 2 columns, the first being alpha names and the second being values that are determined by sum functions. When I sort, the alphas sort as expected but the sum function cells do not, and therefore the data is no longer properly aligned. How can I sort the alpha and sum function cells together? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to sort data that is the result of a sum function
I selected both columns. Only the alpha column sorts. The numerical (sum
function) column does absolutely nothing - doesn't sort or change any values. If I select the value column only, it still does nothing. "ilia" wrote: Select both columns prior to sort operation. Also, if the value returned by the sum functions changes due to sorting, you may get incorrect results. Provide more information on your exact data structure. On Nov 20, 4:36 pm, BCClocks wrote: I am trying to sort 2 columns, the first being alpha names and the second being values that are determined by sum functions. When I sort, the alphas sort as expected but the sum function cells do not, and therefore the data is no longer properly aligned. How can I sort the alpha and sum function cells together? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort column by formula result | Excel Discussion (Misc queries) | |||
| Enter data and display function result in same cell | Excel Discussion (Misc queries) | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
| sort data with the same result | Excel Worksheet Functions | |||
Hybrid Mode
