Codes Required
MatchIfUp or MatchIfRev
Searching for an item in a column from bottom to top. Will search for item in ...
Apr8
HMatchIf_Multi
Returns column if an item from list of items was found in a row. Similar to ...
Oct30
MatchIf_ThenDelete
Searches for an item in a column, then if found, delete that cell (not clear, ...
2018Jun17
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
Similar codes
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
TextPercentageMatch
Matching any part of a string in another , then returns 0 if not match, Or ...
2018Jun26
Between2int and Between2intinc
Checks if number between two numbers, with or without considering those numbers. ...
Mar23
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
Barcode Generator
Pure ASP Classic barcode generator This is one of my past findings, I will be ...
2020Feb1
UnMergeFill
Unmerges all merged cells and duplicate cell contents into them. In another ...
2019Apr16
Checks if URL is valid
Checks if URL is actually working. Uses XMLHTTP object to see if that URL ...
2018Dec9
RunFromTemp
Check if an Excel file is running from 'Temp' location or regular folder This ...
2018Jun17