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.
Function Arguments
Type
Range
Constraints
Must match the dimensions of SelectedRange
If Blank
Function Error
Type
Range
Constraints
Must match the dimensions of CriteriaRange
If Blank
Function Error
Type
Range/String/Boolean
Constraints
Max 255 char
If Blank
Does not concatenate any cells
Type
String
Constraints
Max 255 char
If Blank
","
Excel Formula Bar Example
=jCombineIF(J16:O16,J15:O15,TRUE,";")
Function Composition
Argument Name
Example Mapping
Explanation
Function Name
=jCombineIF()
The name of this function.
CriteriaRange
J16:O16
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.