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
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
NavigatePost
Reads content of webpage with optional post data
two main differences from
2023Jan14
Resize_Me2 + Resize_Me3
Resizes Excel window to certain small size and location (hard-coded) and hide ...
2020Dec11
HTMLDecode + HTMLEncode
Decode and encode back a string using HTML Technically found online, but ...
2019Aug9
