Search results 57

Sorted from new to old.

MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

2024Jan13

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

2024Jan11

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

2024Jan9

CutString9

Cuts from CutFrom starting from any of items found from ...

2024Jan7

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

2024Jan1

ANStrFind_AndOrAdd

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

2023Dec19

MathInsideANString

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

2023Nov20

ReplaceStrings

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

2023Nov11

Range2Block

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

2023Mar6

ANStr2Range

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

2022Nov11

Range2ANStr

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

2022Jul19

CreateUniqueList

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

2022Apr26

ANStrSort2

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

2020Sep24

CreateList_Matching

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

2020May13

Column2AnString_Unique

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

2020May6

ANSQLWherein

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

2020Jan6

1 2 3 4