jCombineIF()

Estimated reading time: 4 minutes

Function Summary

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.

For an example of this function, see Lab Create: Using the Retain Feature.

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.

Usable In These Functions