There is two function that is missing in excel 2013, which is Unique and Filter.
In this picture below here, the Resulting Item utilizes a "Unique" function from google, and Resulting Label utilizes a join and filter function =JOIN(", ",FILTER(C:C,A:A=E2)).
How do i perform this in excel 2013 for this two cells?
delete-duplicate-values-scheme.png
Bookmarks