Similar codes
CleanArray
Cleans array of unwanted items This usually needed after you merge two arrays, ...
2021Sep22
CountDuplicates
Counts how many duplicates found in a range of Excel cells. Basically how many ...
2020Oct31
COUNTIFS as Rank
Simplest way to rank among peers. used COUNTIFS in case we need to add more ...
2022Jan1
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator ...
2018May22
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
gsplit usage
How to use gsplit to split large files into smaller parts to allow to read it. ...
Feb7
BS3 Checks
Check boxes with Bootstrap colors
From
2020Oct30
WorkbookSaveAsk_ANmar
Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...
2018Jul17
