XL 2K7 - can't sort values from formulas???

[cmwells1]

Entered numeric values in columns A-C and rows 1-5. In column E,
entered numeric values 1-5. In column F, entered formula to add
values in columns A-C:

=A1+B1+C1

then copied it down through row 5.

Selected range E1:F5, clicked Sort, selected Column F from drop down,
left Sort On set to Values, and selected Largest to Smallest in the
Order drop down.

Only column E got sorted!

After a half dozen sanity checks, copied the values from column F,
clicked in G1 and selected Paste Special - Values and clicked OK.
Selected range E1:G5 and sorted on column G (Largest to Smallest) and
the sort worked EXCEPT the column with the formulas remained
unchanged.

"Feature" or bug?

 

[Gord Dibben]

Select A1:F5 before the sort.

Selecting E1:F5 sorts only those columns so the formulas in F still refer to the
same values in columns A:C which are unchanged.

Not a bug, just make sure you select all columns before sorting.


Gord Dibben MS Excel MVP

 

[cmwells1]

Select A1:F5 before the sort.

Selecting E1:F5 sorts only those columns so the formulas in F still refer to the
same values in columns A:C which are unchanged.

Not a bug, just make sure you select all columns before sorting.

Gord Dibben MS Excel MVP









- Show quoted text -

Thanks, Gord. Although I do feel a bit like Homer Simpson at the
moment: DOH!