looking for duplicates & unmatched between two columns

[Michael]

Hi - I'm looking for a function that will look at a cell (containing
text) in one column and then look to a range of cells in another column
and if a match is found to indicate "1" if not found to indate "0"

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon

 

[Dave Hawley]

Hi

Try
=IF(COUNTIF($A$1:$A$100,B1),1,0)

Where B1 houses the text to look for and A1:A100 is the range to look
in.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****