Forum Discussion
extract unique values matching a text string
I have two columns (A and B). Column A contains the dates and Column B contains the names of people who are required to attend the duty. Now based on this can i have names of people and just below th...
Hello Sergei SergeiBaklan and Hi Twifoo Twifoo
By all means this is not a regular project and I am really excited to see this "ALL You Can Eat Excel Buffet"... You guys went above and beyond the MVP award. So I'll be nominating you for an imaginary award as follows:
Excel Nobel Prize 2019 goes to Sergei Baklan
Excel Oscar 2019 goes to Twifoo
I also came out with a VBA solution to add to the series. But, anyway that was too much fun.
Nabil Mourad
Hello nabilmourad,
balaram51 sought, and you eagerly waited, for a formula solution so I gave one. My later formula is inevitably an upgrade of the previous one.
Cheers,
Twifoo