Help on use of transpose formula...

[erkamu]

Hello,
I have the following table
Column A-list of email addresses
Column B-list of bosses of people behind d email addresses.
Different bosses repeat differently in column B as they have different number of people from A that report to them.
What I need?
In column C to have list of bosses without duplication.
In Column D , E, F, G, H...etc to transpose from vertical to horizontal email addresses of employees that report to respective Manager.
Thank you.

[hansolu]

Hi,

if you use a new version of Excel you can use the UNIQUE formula to create a unique list of bosses. Then with the function =TRANSPOSE(FILTER... you can spill the employes horizontal to for each unique boss.

[erkamu]

Unfortunately that solution dies not work on nt version of excel (16.0.11929.20978)

[AliGW]

Update your forum profile, please, which still says Excel 2010.

[erkamu]

Updated. Sorry for not noticing that earlier.

[erkamu]

Update your forum profile, please, which still says Excel 2010.

Updated. Sorry for not noticing that earlier.

[alansidman]

Please read the yellow banner at the top of this page on how to attach a file.

[erkamu]

Please read the yellow banner at the top of this page on how to attach a file.

Thanks for advice.

[hansolu]

Hi

okay, then an array formula : =+IFERROR(INDEX($B$3:$B$19, MATCH(0,COUNTIF($C$2:C2, $B$3:$B$19), 0)),"")
Afterwards just show the n-th finding of the Boss Name and get the employee name.

Example attached.

[erkamu]

Hi

okay, then an array formula : =+IFERROR(INDEX($B$3:$B$19, MATCH(0,COUNTIF($C$2:C2, $B$3:$B$19), 0)),"")
Afterwards just show the n-th finding of the Boss Name and get the employee name.

Example attached.

Dear Hansolu,
thanks for your help. It worked. Index function is sth difficult to understand how it works.
When I get stuck in xls in most of the cases it is either because I do not know INDEX or OFFSET. Seems they are qiote powerfull....