Similar codes
Column2AnString_Unique
Creates list of unique items found in a column, returns string with items ...
2020May6
MatchIfUp or MatchIfRev
Searching for an item in a column from bottom to top. Will search for item in ...
Apr8
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
Special chars
How to type special characters in keyboard using ALT + keypad numbers I also ...
2021Oct13
TextPercentageMatch
Matching any part of a string in another , then returns 0 if not match, Or ...
2018Jun26
RowsCount
Get total number of rows for a certain worksheet in certain workbook workbook ...
2018Jun22
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 ...
Apr30
Random Codes
HTML_InsideTag_ByIndex
Checks if LocIndex is found between open and close of HTMLTag or between close ...
Feb28
Resize_Me2 + Resize_Me3
Resizes Excel window to certain small size and location (hard-coded) and hide ...
2020Dec11
DB_Connect_Install
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
2020Mar24
