Forum Discussion
Array formula not working in my computer
Hallo People, I want to extract values of a row which has duplicates into seperate columns. I used the below formula {=https://exceljet.net/excel-functions/excel-iferror-function(https://exce...
Hi,
It is working !! The syntax was wrong.
=IFERROR(INDEX(names;SMALL(IF(groups=$E5; ROW(names)-MIN(ROW(names))+1);COLUMNS($E$5:E5)));"")
This worked. The snytax on this excel was seperated by semi colons and not commas.
Thanks and best regards,
Dakkshinamurthi Pan Subramanian
An array formula to correspond to SergeiBaklan 's Power Query layout
= MAP(UNIQUE(Groups),
LAMBDA(grp,
TEXTJOIN(", ",, FILTER(Names,Groups=grp))
)
)