Similar codes
Column2AnString_Unique
Creates list of unique items found in a column, returns string with items ...
2020May6
CellRead (SimpleLookup)
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
Rows 2 Cell
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
Add2Column
Quickly adds value to certain column in Excel sheet As usual, you can define ...
2020Jan3
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator
2018Apr23
ANStrList functions
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
ANStrRead + ANStrSave + ANStrSearch
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14
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
User-Defined Formatting
Apply special Conditional Formatting, color cells based on their values. This ...
2019Jan9
IsPrime
Checks to see if a number is a primary number. Prime numbers are commonly found ...
2018Jul25
