Going back to original location

[Té]

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.

 

[Ivor Davies]

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