keep cell data in reference after sorting

B

Buster

What reference formula keeps the cell data in the dependent cell even after
the precedent reference cell is sorted to a different place?
 
J

Jim Rech

There is none. Formulas are not altered by a sort (in the R1C1 reference
system sense). So a formula that refers to the cell above it before a sort
will still do so after a sort.
 
Top