Search results 31

Sorted from new to old.
Card image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Card image
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Card image
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Card image
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

Card image
IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

Card image
RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

Card image
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Card image
Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

Card image
MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

Card image
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

Card image
Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

Card image
Match3

Matching three values at the same time in three columns Just like Match the ...

Card image
Match2

Matching by two values at the same time in two columns Just like Match the ...

Card image
MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

Card image
CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...