Hi
I have 500 rows of data, in column B is a Task and column C has a location or is empty
The information held in column C is located in column B.
Ideally I would like to check each cell in column C and compare to all cells in Column B, if their is a match I would like Column D to hold a value of "Y" or "N" on the row that matches.
EXAMPLE DATA
B C D
example A FRANCE N
NICE N
DUBAI N
FRANCE Y
Any ideas welcome.
I have 500 rows of data, in column B is a Task and column C has a location or is empty
The information held in column C is located in column B.
Ideally I would like to check each cell in column C and compare to all cells in Column B, if their is a match I would like Column D to hold a value of "Y" or "N" on the row that matches.
EXAMPLE DATA
B C D
example A FRANCE N
NICE N
DUBAI N
FRANCE Y
Any ideas welcome.