Counts how many cells with data in a row, starting from certain column until ...
Search for 2 items in 2 columns starting from last row upword (Starting with ...
Counts how many values are True (or anything) in an array of boolean values ...
Simplest way to rank among peers. used COUNTIFS in case we need to add more ...
Finds last occurrence of a match in a column Finds the row of last time an ...
Reads setting saved in columns J:R Just like SettingRead, but when we have ...
Matching 4 values at the same time in 4 columns Just like Match the function, ...
Matching three values at the same time in three columns Just like Match the ...
Matching by two values at the same time in two columns Just like Match the ...
Horizontal match for a value in a row Horizontal MatchIf, returns column ...
The best Match I created, return 0 if not found, kind of CountIF+Match ...
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
50 chars max.