Search results 47

Card image cap
ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

Card image cap
MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

Card image cap
ReplaceStrings

Replace strings found in list of strings from inside a string, does taht make ...

Card image cap
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Card image cap
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

Card image cap
Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

Card image cap
CreateUniqueList

Create list of unique items from a column into another column This is similar ...

Card image cap
ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

Card image cap
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Card image cap
Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

Card image cap
ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

Card image cap
Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...