Forum Discussion
Mail merge file help
Hi, I have a fiddly question based on some HR data. I have a filtered list of employees by name and details and then a series of look-up columns that pull through their Manager, Head of Dept, Directo...
=IFNA(DROP(REDUCE("",A15:A26,LAMBDA(x,y,VSTACK(x,TOROW(FILTER(A3:E12,BYROW(F3:U12=y,LAMBDA(r,OR(r)))))))),1),"")
This formula returns the intended result in my Excel for the web sheet.
=IFNA(DROP(REDUCE("",A15:A26,LAMBDA(x,y,VSTACK(x,TOROW(FILTER(A3:E12,BYROW(F3:U12=y,LAMBDA(r,OR(r)))))))),1),"")
This formula returns the intended result in my Excel for the web sheet.
That's phenomenal thank you!