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
Delete_Unwanted_Rows
Delete rows in a different way I used to delete rows by looping through those ...
2020Apr14
MatchLastIf
Finds last occurrence of a match in a column Finds the row of last time an ...
2019Jun12
Frm6 - ANmaMultiSelect
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
Column2AnString_Unique
Creates list of unique items found in a column, returns string with items ...
2020May6
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
Rows 2 Cell
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
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
Special chars
How to type special characters in keyboard using ALT + keypad numbers I also ...
2021Oct13
Windows 10 video files and OneDrive
Fixing generating videos thumbnail in Windows 10
Download app from
2020Oct31
IntlIsAlphaCharacter
Test if a character is alphanumeric, regardless of the code page or language ...
2020Mar21
