keep cell data in reference after sorting
 

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

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.

--
Jim
"Buster" wrote in message
...
What reference formula keeps the cell data in the dependent cell even
after
the precedent reference cell is sorted to a different place?