Similar codes
NMRRank_v2021
Ranks a number among set of numbers. This is part of huge tool, we needed to ...
2021Sep23
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
CleanArray
Cleans array of unwanted items This usually needed after you merge two arrays, ...
2021Sep22
InsertHyperlinks + GetHref
Converts https found in text into anchers < a > Comes with GetHref as bonus ...
2018May13
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
CountDuplicates
Counts how many duplicates found in a range of Excel cells. Basically how many ...
2020Oct31
IntlIsAlphaCharacter
Test if a character is alphanumeric, regardless of the code page or language ...
2020Mar21
