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
SwapNumbers
Swap two numbers variables without using third variable A trick worth saving ...
2022Oct17
VBInstr_Numeric
Finds location of 1st numeric character inside string starting from a certain ...
Feb25
HMatchIf_Multi
Returns column if an item from list of items was found in a row. Similar to ...
Oct30
NumberNumberNumber
Finds 3 numbers in a string by ignoring characters between them. ' example ...
Mar2
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
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
Random Codes
SearchinHTMLTable
Search for a word in a certain column in html table and return the full row ...
Nov12
LastInsertedID_SQL
Get the ID of the last inserted record in a table. There are other methods, ...
2019Jul18
