G
Guest
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.
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.