Search results 72

Sorted from new to old.

XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

2023Nov26

MathInsideANString

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

2023Nov20

Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

GetAmazonPrice

Reading price of an item in Amazon. An AI-generated function with AI-generated ...

2023Apr3

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

2022Nov13

ANStr2Range

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

2022Nov11

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

CreateUniqueList

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

2022Apr26

1 2 3 4 5