Forum Discussion

Copper Contributor

Aug 03, 2019

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

excel

Formulas and Functions

nabilmourad

MVP

Aug 07, 2019

balaram51

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

SergeiBaklan
Diamond Contributor
Aug 08, 2019
nabilmourad

Most challenging part here is to extract list of names for the headers of the resulting table. If names are predefined any variant of regular formula is more preferable.
Twifoo
Silver Contributor
Aug 07, 2019
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