Returns sum of certain column in range (or table) in sheet after applying ...
2021Jan29
Counts how many duplicates found in a range of Excel cells. Basically how many ...
2020Oct31
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...
2022Jan29
Read all Environment variables using EnvDir_All Or quickly get user folder, or ...
2018Jun17