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.

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.