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
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
List names in a certain workbook into sheet. And Deletes those names. You may ...
Jul9
Protect or unprotect a workbook (already open) remotely from another workbook ...
2019Jun2
Returns random IDs (or any column) from SQL Database table, passing number of ...
2018Jul29