Similar codes
NextID_Reset
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
DB Functions (By AI)
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
SQL Cross Apply String_Split with XML Path
SQL select statement to convert list of IDs found in column (from more than row ...
Jan20
FilterSheet_1By1 + FilterSheet_Clear
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
GetColumnIndex
Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...
2021Nov26
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
FilesIn_Array and FoldersIn_Array
Return list of files in a folder back as array.
Similar to
Aug15
COUNTIFS as Rank
Simplest way to rank among peers. used COUNTIFS in case we need to add more ...
2022Jan1
Windows-like drop down menu
Classic-Windows-like dropdown menu using CSS and JS, library in zip is build in ...
2020Aug20
ASCII_Read + ASCII_Save
Reads and saves text file giving its full name Used a lot in my tools, very ...
2018Apr21