Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Splitting Data in a Cell | Excel Worksheet Functions | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |