Search results 63

Sorted from new to old.

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

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

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

ListBox_SelectionCount

Counts how many items selected in a listbox (multi-selection listbox). Works ...

2022Apr21

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

1 2 3 4