Excel Find Data Problem

[Hakala]

Hi, Tek-tippers! I've been asked if I can create "a button or something" to allow our tech writer to check a long Excel file. He wants to know:

Is any of the text in cell A1 in any cell in Column B?
Is any of the text in cell A2 in any cell in Column B?

and so on. So I guess he's looking for duplications between Column A and Column B.

I haven't a clue how to do this. Excel's find feature (Ctrl-f) is too manual, so it takes too long.

Any ideas out there?


Michelle Hakala

http://www.winebird.com/

 

[SkipVought]

Hi,

How about AutoFilter, using a CONTAINS criteria?

Skip,
[sub]
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![/sub]

 

[Rofeu]

or:

=MATCH("*"&$A1&"*",B:B,0)

Cheers,

Roel

 

[DaleWatson123321]

Hi Michelle,

Enter this formula in an adjacent column (C for example), and copy down.

=IF(COUNTIF(B:B,A1),A1,"")

It will test the value in column A, and if it exists anywhere in column B, it will show the value (in column C). And if the value does not exist in column B, the formula will show blank.

Hope this helps. ;-)

Regards, Dale Watson