match/compare cell with cells in a column

[Guest]

Hi,
I am trying to match the contents of a cell in column A to a similar cell,
if it exists in a column B. Once it is found/or not found, it will tell me
and by returning a result and go on to check the next cell in column A to the
cells of column B.
I would appreciate a response, thanks!

 

[JulieD]

Hi Radu

you can use a formula in a third column to do this ... check out Chip
Pearson's notes on working with duplicates at

http://www.cpearson.com/excel/duplicat.htm

Hope this helps
Cheers
JulieD