sorting

[mmb]

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.

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk