Similar codes
FilterSheet_1By1 + FilterSheet_Clear
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
ANmAdvancedFilter
Filter table inside Excel the fast way (using advanced filter) into another ...
2022Sep15
SumOf_3Filters
Returns sum of certain column in range (or table) in sheet after applying ...
2021Jan29
ANmaPivotTable_Clear
Clears all filters in PivotTable and hide the [blank] item from list, pass ...
Dec22
jQuery filtering
jQuery filtering, demo
From
2019Jul9
PivotTable_ShowHideBlankItems
Shows or hides an item or items in a PivotTable filter field. Passing ...
Jan22
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
Excel recovered files
Location of Excel recovery workbooks in your system when Excel crashes, it ...
2023Mar31
ShapeRange_BG
Replaces the background fill of any shape in Excel with an image Not Ready yet, ...
2021Mar27
Save to, Read from, Delete registry key
Save into registry, read from registry or delete a key. Accessible to only ...
2019Jun15
Crypt128
Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...
2018Jun14