looking for duplicates & unmatched between two columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael - 06 Apr 2004 16:25 GMT

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"

Reply to this Message

Frank Kabel - 06 Apr 2004 16:43 GMT

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

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> 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
[quoted text clipped - 3 lines]
> Excel Templates, Training & Add-ins.
> Free Excel Forum http://www.ozgrid.com/forum *****

Reply to this Message

Dave Hawley - 07 Apr 2004 04:45 GMT

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.

Reply to this Message