ExcelBanter - I need a formula to find duplicate entries between 2 files.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I need a formula to find duplicate entries between 2 files. (https://www.excelbanter.com/excel-discussion-misc-queries/58464-i-need-formula-find-duplicate-entries-between-2-files.html)

ammoman

I need a formula to find duplicate entries between 2 files.

L. Howard Kittle

I need a formula to find duplicate entries between 2 files.

With your lists in A2:A? B2:B?, in C2 enter and pull down as far as the list
goes. If the item in column A is in column B then it will be returned in
column C.

=IF(COUNTIF($B$2:$B$500,A2)=0,A2,"")

HTH
Regards,
Howard

"ammoman" wrote in message
...

All times are GMT +1. The time now is 01:24 PM.