Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going back to original location
I have data in a spreadsheet that has filters on it. When I change a number
in one of the columns say for example from 101 to 301, it automatically puts the 301 in order (ascending or descending). The problem that I am having I want to know where the origical location of the 101 was it. For example to start 101 was in cell D11, then when I change it to 301 it jumps down to D115. How can I find out where it would have been had it not been sorted? I tried track changes, but that isnt what I want. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going back to original location
You could try an adjacent column that has the original row numbers for each
of the filtered values. So Column A COLUMN B (with Filter) 1 nnn 2 nnn 3 nnn 4 nnn "Té" wrote: I have data in a spreadsheet that has filters on it. When I change a number in one of the columns say for example from 101 to 301, it automatically puts the 301 in order (ascending or descending). The problem that I am having I want to know where the origical location of the 101 was it. For example to start 101 was in cell D11, then when I change it to 301 it jumps down to D115. How can I find out where it would have been had it not been sorted? I tried track changes, but that isnt what I want. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where is the original data location in a worksheet stored? | Excel Worksheet Functions | |||
How can I copy many formulas and keep original cell location? | Excel Discussion (Misc queries) | |||
Revert back to original sort | Excel Discussion (Misc queries) | |||
How to revert back to the original file name in a hyperlink | Excel Discussion (Misc queries) | |||
The Template Wizard retains the original location for my database | Excel Discussion (Misc queries) |