legalhustler
Well-known Member
- Joined
- Jun 5, 2014
- Messages
- 1,171
- Office Version
- 365
- Platform
- Windows
I have a single cell formula that uses the TEXTJOIN function and returns multiple values. Although some answers are returning duplicate values (which is working as designed b/c multiple instances do appear when I do the look up), but I want to only show the unique values in my single cell solution. For example my formula is returning the following in a single cell, separated by commas:
5,15,20,15,25
I want to further amend my formula below so that it only shows 5,15,20, 25
={TEXTJOIN(",",1,IF(Customers!$B$1:$B$1000=$A3,IDs!$A$1:$A$1000,""))}
Any help is appreciated. TIA!
5,15,20,15,25
I want to further amend my formula below so that it only shows 5,15,20, 25
={TEXTJOIN(",",1,IF(Customers!$B$1:$B$1000=$A3,IDs!$A$1:$A$1000,""))}
Any help is appreciated. TIA!