• This topic is empty.
Viewing 1 post (of 1 total)
  • EXCEL question – text has moved, where to?
  • brakes
    Free Member

    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.

Viewing 1 post (of 1 total)

The topic ‘EXCEL question – text has moved, where to?’ is closed to new replies.