Returns sum of certain column in range (or table) in sheet after applying ...
2021Jan29
Filter table inside Excel the fast way (using advanced filter) into another ...
2022Sep15
Clears all filters in PivotTable and hide the [blank] item from list, pass ...
Dec22
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
Search for a word in a certain column in html table and return the full row ...
Nov12
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
Fixing generating videos thumbnail in Windows 10
Download app from
2020Oct31
ASP based AJAX example to call mdb database using
2020Sep7
Calculate maximum of array of numbers or Minimum of array of numbers Also, ...
2019Dec31