Download the featured file here: [ Ссылка ]
In this video, I demonstrate how to combine concatenation with an IF condition.
In the first scenario, I only want to concatenate a cell if it contains a text value. If the cell is empty I don't want it to be included in the concatenated text string.
In the second scenario, I want to concatenate values in a column if a condition is met in another column. I use the TEXTJOIN function to achieve this.
------------------------
Ещё видео!