Hi All, I have a question on getting unique values based on a criteria in a cell. See below
ColumnA ColumnB
John Green
Alice Yellow
Mary Red
Mary Green
Mary Yellow
John Red
Mary Red
So I would like to write a formula to a cell where it will look at column A, find name Mary in column A and give me Unique values for Mary for the colors she used. I am saying unique since you can see Mary used Red 2 times but should be listed once. I am able to use array function with filter and unique but it returns unique values in separate cells. I would like to have an output in a single cell like this: "Red/Green/Yellow"
Thank you
ColumnA ColumnB
John Green
Alice Yellow
Mary Red
Mary Green
Mary Yellow
John Red
Mary Red
So I would like to write a formula to a cell where it will look at column A, find name Mary in column A and give me Unique values for Mary for the colors she used. I am saying unique since you can see Mary used Red 2 times but should be listed once. I am able to use array function with filter and unique but it returns unique values in separate cells. I would like to have an output in a single cell like this: "Red/Green/Yellow"
Thank you