drums4monty
12-09-2008, 07:00 AM
Hi
I have a spreadsheet with Columns A - F. I need to check Col C which is full of Surnames and if the name is repeated under each other I would like to put the word OK in Col F for both of the names. This only needs to happen if the repeated names are adjacent to each other. If the name is repeated a few rows further down then this should not count.
Is this possible?
I have a spreadsheet with Columns A - F. I need to check Col C which is full of Surnames and if the name is repeated under each other I would like to put the word OK in Col F for both of the names. This only needs to happen if the repeated names are adjacent to each other. If the name is repeated a few rows further down then this should not count.
Is this possible?