Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting
how do sort column with formula? Please advise.
for example: column N has a formulas subtotalling all my amount from row b2 to M2. Now I need to sort the column N, It is not letting me do it. It si sorting by cell Number? Please help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting
If you are trying to sort just Column N then you cannot do that, you must
sort all the columns that the formulas in Column N refer to. ie if the formulas in Column N are summing the cell in B:M in the same row as the formula then highlight B2:N100, or whatever the last Row is, and then sort on Column N. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "mmb" wrote in message ... how do sort column with formula? Please advise. for example: column N has a formulas subtotalling all my amount from row b2 to M2. Now I need to sort the column N, It is not letting me do it. It si sorting by cell Number? Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting | Charts and Charting in Excel | |||
Sorting | New Users to Excel | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Help With Sorting | Excel Discussion (Misc queries) |