Cleans array of unwanted items This usually needed after you merge two arrays, ...
2021Sep22
Counts how many duplicates found in a range of Excel cells. Basically how many ...
2020Oct31
Simplest way to rank among peers. used COUNTIFS in case we need to add more ...
2022Jan1
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
Returns list of files found in a folder, list separated with custom separator ...
2018May22
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
Fills in more rows at end of a range Used to add more rows at end to have all ...
2022Mar11
Responsive Tags Input With Autocomplete Examples using Bootstrap 4 Originally ...
2020Oct9
Online tool to create css3 text shadow, free. Technically, generate the CSS3 ...
2019Oct23