formula

[mort1703]

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.

 

[Dave Patton]

A quick guess based on your very limited data example.

Excel 2010
	A	B	C	D	E	F
1		A	France
2		Nice		FALSE	FALSE	F
3		Dubai		FALSE	FALSE	F
4		France		TRUE	TRUE	T
5		USA			FALSE	F
6		Canada	Canada		TRUE	T
7		France			TRUE	T
8
8a

Cell Formulas
Range	Formula
D2	=(B2=$C$1)
E2	=COUNTIF(C:C,B2)>0
F2	=IF(COUNTIF(C:C,B2)>0,"T","F")