Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Topic starter
I have 2 worksheets, one is the original and one has been modified.
the modifications mean that some of the (unique) cell contents have moved to another cell.
I need to build a 3rd sheet that will tell me where those cell contents have moved to in relative terms e.g. 2 rows across and 3 cells down.
is this possible? I'm thinking INDEX, MATCH and FIND but can't work it out. I could do it with MATCH if it was just one column.
Posted : 09/10/2013 4:21 pm