Excel - Want to sort by formula value without losing formula

[HappyPill]

Hi. I have a range of cells containing a formula. I want to sort that
column by the values of the formula without losing the formula (therefore,
can't copy / paste special just the value because that deletes the formula).
Is there any way I can sort that range of cells according to the value of the
formula in the cell and keep the formula?

 

[Gary''s Student]

Say the formula is in C1 thru C10:

=A1 + B1
=A2 + B2
..
..
..

just sort columns A thru C by column C either ascending or descending.

 

[Tyro]

I don't quite know what you mean. I can sort a column by the values the
formulas display and I don't lose the formulas. I'm using Excel 2007.

Tyro

 

[Sandy Mann]

Tyro,

Are you saying that if the column of formulas is on in the same rows as the
original data you can still sort the column of formulas?

--
Regards,

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

 

[whitake77]

I too am having the same problem, except I am using the "if" function, pulling data that I want to sort which is spread from row 1 to 45000.