Similar codes
FilterSheet_1By1 + FilterSheet_Clear
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
CreateUniqueList
Create list of unique items from a column into another column This is similar ...
2022Apr26
RemoveDuplicates
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
SumOf_3Filters
Returns sum of certain column in range (or table) in sheet after applying ...
2021Jan29
ANmaSQL_UpdateDateStatement
Creates "Update Table " SQL statements to be executed inside SQL to modify ...
2022Jul4
Frm6 - ANmaMultiSelect
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
Add2Column
Quickly adds value to certain column in Excel sheet As usual, you can define ...
2020Jan3
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 ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
Latest records date and count
Find how many items in table, with column DateAdded is the latest DateAdded in ...
Nov2
Bootstrap full calendar
Full, simple and powerful, with AJAX, and template systems
From
2019Sep16
FixENTERS_File
Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...
2018Jul7