Forum Discussion
List Duplicates in One Cell Based on Values in Another Cell
I have a list of assets that I am trying to list those who don't have access to each in column F. If everyone has access, then return a blank. I've tried different formulas but messed ar...
=TEXTJOIN("; ",,FILTER($B$2:$B$9,($A$2:$A$9=A2)*($D$2:$D$9="Does not have access"),""))
This returns the expected result in my sheet.
=TEXTJOIN("; ",,FILTER($B$2:$B$9,($A$2:$A$9=A2)*($D$2:$D$9="Does not have access"),""))
This returns the expected result in my sheet.
- Thank you!
