Hello forum,
I have been struggle for a while now trying to extract unique values to separate columns (in my example D21, E21, F21, G21, H21 etc as long as it has unique values ) but all samples i find is for filling row by row and I have not been able for it to work for filling one row along columns.
I then looked at the new function "TEXJOIN", that separate values with an delimiter instead, less stylish but seemed easy to do, but I still struggle when it comes to two criteria and another sheet.
I have two test functions one with INDEX and AGGREGATE and one with TEXTJOIN, I can pull out one Name but not all of the unique values....
How would this be solved? I have attached an example and it is in D21-L21 I want the result to be entered if all is needed, TEXTJOIN is less elegant in this solution if nothing else works.
Thanks
Bookmarks