ExcelBanter - matching from one column to another

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

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

- - matching from one column to another (https://www.excelbanter.com/excel-discussion-misc-queries/120761-matching-one-column-another.html)

jbressma

matching from one column to another

So I have two lists in Excel of about 1500 clients names. I am basically
trying to find out if any of the client names in Column A also appear in
Column B. Is there any way for Excel to do this for me? Thanks!

All times are GMT +1. The time now is 09:30 PM.