software

I have a worksheet that has over 13,000 records. Column A contains company
names; Column B contains the parent company name, if any was listed. I can
filter column B to nonblanks or use a filter drop down box. I need to find
all the cases where any name in column A matches the name in Column B. For
example, if colum B says Smith Management LLC, I need to find Smith
Management in column A. There are several hundred names in Column B after
filtering to nonblanks.

Just use Vlookup, as in:

=vlookup(a2,B:B,1,false) and copy down.

If it returns #N/A, then there was no match.

--
Regards,
Fredquot;Richard Bquot; gt; wrote in message
...
gt;I have a worksheet that has over 13,000 records. Column A contains company
gt; names; Column B contains the parent company name, if any was listed. I can
gt; filter column B to nonblanks or use a filter drop down box. I need to find
gt; all the cases where any name in column A matches the name in Column B. For
gt; example, if colum B says Smith Management LLC, I need to find Smith
gt; Management in column A. There are several hundred names in Column B after
gt; filtering to nonblanks.