 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
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