How to I remove duplicate words when using =TEXTJOIN() function in google sheets or excel
I am trying to find a function that I can use that will eliminate duplicate wording when i join two cells together. I will attach a picture to show you what my ideal return is.
For the Row 1&2 column, this is the function I used
=textjoin(":",True,A2,B2))
but i would like to find a function that will return me the Ideal Return instead. I am not looking to use the find and replace feature, as I would like to document each step I made, so a function would be best.
Solution
What about this one?
=IF(EQ(A2;B2);A2;TEXTJOIN(":";true;A2;B2))
nothing fancy though, if you want the fancy one, the answer with flatten from Harun24hr is better.
But it is easy in what it does, if the cells are the same, then take the first cell, otherwise, concat the results.
- How to combine multiple conditions in a PowerShell if-statement
- I get an error when I end the if statement with a concluding else statement
- Does PHP have short-circuit evaluation?
- Why is this code still adding 1 to i even when the if statment that does so isnt called in C?
- error compiling in c user input
- R Conditional IfElse With Random Values
- Can not get past illogical line pep8 error
- smarty help with if statement
- 'if' must have both main and 'else' branches if used as an expression
- What is the standard for choosing "when" vs "if/else" in Kotlin?
- Python script continuously repeats the first if - else statement
- Why does python use 'else' after for and while loops?
- Use of ternary operator instead of if-else in C++
- Evaluate boolean environment variable in Python
- How to use if/else statement in terraform for loop
- change number grade to letter grade
- How to debug this substring matching code?
- If condition is getting skipped even if the condition is true
- Assign value to all rows based on condition being fulfilled or not
- Looping through a list in Python
- Why does if (fork() || fork() || fork()) behave differently?
- Python if not == vs if !=
- Discord.py | If statement not working correctly
- Angular 17 - In @if syntax, how to store returned value from a function in a variable and use it in the same @if block
- Angular: ng-content doesn't render with *ngIf then else
- How to get the next Bi-weekly date based on a given start date and today's date in Google Sheets
- What is the best way to refactor an if else branch
- Unreachable code in if-else structure
- Python if/else/elif
- Ternary conditional operator in Scala