Search results 55

Sorted from new to old.

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Aug20

ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

Jul30

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Jul13

Min_No0s

Getting the minimum number from an array excluding zeros.

Jun5

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Apr15

MultiRead_JSON

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

Jan13

ANStringListRead_JSON

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

Jan9

ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27

XMLRead

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

2023Nov26

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

2023Aug14

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23

ArrSort_4Arr

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

2023Apr14

LstCustomSelection_Refresh

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

2022Aug31

1 2 3 4