-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
textjoin(if
-
D
Combine Cells when same Value in another column
Hi, I'm struggling to find a way to make some textjoin alike formula with IF condition and also "unique" too in order to combine results that share same value. I have something as per below example: ID Type Name1 Type1 Name1 Type2 Name2 Type2 Name3 Type1 Name4 Type1 Name4 Type1...- Dani_LobP
- Thread
- condition formula textjoin textjoin(if unique
- Replies: 10
- Forum: Excel Questions
-
D
Textjoin with multiple criteria
Hey everyone, I have this excel table in Column A and B, but I want to bring into the form of D and E: ABCDE1KeyActualCategoriesKeyActualCategories21IT-Strategie1IT-Strategie32IT-Strategie2IT-Strategie43IT-Strategie3IT-Strategie54Vorgaben&Maßnahmen4Vorgaben&Maßnahmen65IT-Strategie5IT-Strategie...- Dag2
- Thread
- excel textjoin textjoin(if
- Replies: 3
- Forum: Excel Questions
-
S
TEXTJOIN using IF & "addtext" but remove if cell is blank.
I am trying to TEXTJOIN to create links to my filepaths, whilest adding text that I need - but I don't want it to bring back anything when I have no vaule. Any help would be massivly appriciated. ABCDEFGHIJKLMNOPQRSTUV1File PathStyle...- Sellsie11
- Thread
- addtext remove blank cells textjoin textjoin(if
- Replies: 7
- Forum: Excel Questions
-
I
TEXTJOIN IF- not listing all items (products)
Hello everyone, this is my first thread here in this forum. For quite some I am using excel now with great fun and passion. Thanks to this forum I was able to solve many obstacles when I got stucked. However, today I really need to ask for help as I am stucked for a few days already. So here...- impressive
- Thread
- if textjoin textjoin(if
- Replies: 12
- Forum: Excel Questions
