Codes Required
Similar codes
Column2AnString_Unique
Creates list of unique items found in a column, returns string with items ...
2020May6
ANStrList functions
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
ANStrFind_AndOrAdd
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
Dec19
Frm6 - ANmaMultiSelect
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
ReplaceStrings
Replace strings found in list of strings from inside a string, does taht make ...
Nov11
CreateList_Matching
Creates list of items found in rows, where these rows match a value in another ...
2020May13
PivotTable_ShowHideItems
Show or hide item (or items) in PivotTable for a certain field. Passing ...
Jan23
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 ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
COUNTIFS as Rank
Simplest way to rank among peers. used COUNTIFS in case we need to add more ...
2022Jan1
VBInstr (or Instr parameters)
The great function InStr I use a lot has a small confusing part. Which string ...
2019Jan9
Webapp-ScrollAreas
Allow website to have scroll bars on areas, like a web app Applied in ANmar. ...
2018May19