Forum Discussion
1:many:many reverse report
Hello I have two tables which combined have a 1:Many:Many relationship as shown in the attached example file. I have tourists that have visited destinations, and destinations with attractions. T...
=DROP(REDUCE("",UNIQUE(E4:E14),LAMBDA(x,y,VSTACK(x,IFNA(HSTACK(y,SORT(UNIQUE(XLOOKUP(FILTER(D4:D14,E4:E14=y),B4:B11,A4:A11)))),y)))),1)
With Office 365 or Excel for the web you can apply this formula.
OliverScheurich Thank you so much, that worked perfectly. And it looks like a very smart solution, the approach is new to me. Shows you have a deep understanding of the subject. Kind regards, Marek