Hello,
I'm stuck on an excel problem... I know what to do I just don't know how to do it.
so here is my problem.
I have a table of about 800 rows.
something like this
PartNumber Location NewLocation
PartA L09 R9
PartB L08 Q3
PartC K1 R38
I need to sort this spreadshet in such a way that if the first row has new location as R9 then the next row will have Location as R9.... and whatever the newLocation for that part is, it will be the Location for the following row (part)
so that my table will be sorted such as this
PartNumber Location NewLocation
PartA L09 R9
PartB R9 P3
PartC P3 G3
We're moving a few parts around in our department, so if I pull out a part out of lets say location 09 and the new location is R9, i now need to know where the new location for part R9 would be...... Is there a query/macro that I can run.. can someone help me out.. I have no idea how to accomplish this...
thank you
PS.... I'm using excel2007
hello there
If I have understood you correctly you want the location to show the value of the new locationf or the value above so if your second location cell was at B3 and you placed the formula below in B3 then what ever the value in C2 would be in the location column below
=OFFSET(B3,-1,1,1,1)
I hope I understood you
j