Similar codes
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
CountRowCells
Counts how many cells with data in a row, starting from certain column until ...
Sat 11AM
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
MatchLastIf
Finds last occurrence of a match in a column Finds the row of last time an ...
2019Jun12
Recently by developer
CountRowCells
Counts how many cells with data in a row, starting from certain column until ...
Sat 11AM
CalculateQuarterText
Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...
Jun10
JSON_To_Table
An attempt to read json into table. This one is a work in progress, tested and ...
Jun6
Random Codes
Excel crashes when File > Print
During generating Print Preview, Excel crashes. Applies to some files, not all, ...
2021Mar6
Delete_Unwanted_Rows
Delete rows in a different way I used to delete rows by looping through those ...
2020Apr14
