Sorting with Calculations

[Tina.Covis]

When you sort in Excel 2000 and their are calculations or
references to another cell, we recieve #NAME?. Is there
any way to get the references to change when the sort
takes place? For instance if D4 has Max(E5,E7) and the
sort moves the info that was in cell E5, E6 and E7 to
E15, E20 and E21 but not D4, how can you get D4 to now
reference the new cells?

 

[Bernie Deitrick]

Tina,

No. Only by moving the cells by dragging or shift-dragging will you be able
to update the formula references properly. Sorting is a different beast.

HTH,
Bernie
MS Excel MVP