Thread
:
Lookup and Textjoin help
View Single Post
08-25-2021, 02:30 AM
p45cal
Windows 10
Office 2019
Expert
Join Date: Apr 2014
Posts: 871
In cell B2:
Code:
=TEXTJOIN(", ",TRUE,UNIQUE(FILTER(Sheet1!$C$2:$C$31,Sheet1!$B$2:$B$31=A2,"None")))
copied down.
p45cal
View Public Profile
Find all posts by p45cal