|
Rgx.COUNTIF function
Counts the number of values within a range or array that match the Regular Expression Pattern.
Rgx.COUNTIF as a multi-threaded non-volatile function.
Rgx.COUNTIF Syntax
Rgx.COUNTIF(SearchThis, RegExp, Case_Sensitive)
The first 2 parameters are required; the last parameter is optional.
SearchThis (required)
A rectangular range, array or expression that returns a rectangular array to be searched for matches to the Regular Expression Pattern. All rows and columns within the rectangular array are evaluated for a match.
RegExp (required)
Specifies the Regular Expression to be used when matching values from SearchThis
Case_Sensitive (optional)
TRUE to make the pattern-matching case-sensitive. The default is FALSE.
Rgx.COUNTIF Example
.png)
The Numbers data is in A36:A42 and the Regular Expression Pattern is in C35. There are 6 numbers that match the pattern. The Numbers data is all textual numbers.
|
