How do I pull text that is common across the rows where:
Account Name Unique Identifier Company ABC - helloworld - HQ - hi Company ABC Company ABC - byeworld Company ABC Whatnow - Space Whatnow Whatnow - Earth - HQ Whatnow
What formula would work to retrieve the desired result in the 2nd column?
Last edited by excellenthelp; 12-03-2020 at 08:09 PM.
It requires helper columns. Are you ready for this?
Try to attach a sample worksheet
Quang PT
For some reason, this won't let me attach. So I just am going to copy and paste the sheet here:
Top-Level Account Name Account Name Helper Column A?? Helper Column B?? Company ABC Company ABC - Byeworld Company ABC Company ABC - Helloworld Whatnow Whatnow - Space Whatnow Whatnow - Earth - HQ ABC Computer - New York - HQ ABC Computer - LA ABC Computer - Louiseville XYZ Champ - HQ XYZ Champ - KY XYZ Champ - Miami Lonely Inc Twins Corp - A Twins Corp - B
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks