Finding Text in a column

[mmmarty]

Hi,

I have 10000+ names imported to col B monthly. Often duplicate names are found in this Col.

I also have 500 unique names imported to col A weekly.

Is there some way I can flag all cells in Col B which have duplicate names found in Col A ?

 

[Lakelands01]

Try this formula.

=IF(ISNA(MATCH(B1,$A$1:$A$20,0)),TRUE,B1)

I have inserted a dummy column, which has the formula. The cell has a conditional format.

Book1
	A	B	C	D
1	a	a	a
2	b	a	a
3	c	a	a
4	d	b	b
5	e	b	b
6	f	b	b
7	g	c	c
8	h	c	c
9	i	d	d
10		d	d
11		e	e
12		e	e
13		e	e
14		f	f
15		f	f
16		f	f
17		g	g
18		g	g
19		h	h
20		i	i
21		j	TRUE
22		k	TRUE
23		l	TRUE
Sheet1

 

[PaddyD]

some further options and a recommendation:

http://www.mrexcel.com/board2/viewtopic.php?t=40233

 

[mmmarty]

Thanks,

This will do nicely.