The jCombineIF function concatenates a range or multiple ranges of cells into a single string using a designated delimiter if a certain condition is met. Blank cells are skipped.
This function can be used as a standalone function and does not need to be embedded in another function.
The range J16:O16 will be used to compare values. If a cell in this range matches the CriteriaValue, the corresponding cell in SelectedRange will concatenated. For example, in this case, if J16 = True, then J15 will be concatenated. If J17 = True, then J16 will be concatenated, etc.
SelectedRange
J15:O15
The range J15:O15 will be the values concatenated if the criteria is met.
CriteriaValue
TRUE
The boolean value of True is used as the criteria.
Delimiter
”;”
The semicolon “;” will be used as the delimiter for the concatenation.