Similar codes
CleanArray
Cleans array of unwanted items This usually needed after you merge two arrays, ...
2021Sep22
CountDuplicates
Counts how many duplicates found in a range of Excel cells. Basically how many ...
2020Oct31
COUNTIFS as Rank
Simplest way to rank among peers. used COUNTIFS in case we need to add more ...
2022Jan1
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator ...
2018May22
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
DB Functions (By AI)
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
Rows 2 Cell
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23