Search results 49

Sorted from new to old.

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

Sep30

CutString_JsonKeyValue

Reads value from json string for certain key. Using RegEx Regular Expression. ...

Jul27

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

Jun14

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

May30

FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

May25

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

MaxOfArray

Gets the maximum number from an array. Like

2024Oct24

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

Choose2

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

2024Aug20

ANmaSearch_OrFriends

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

2024Jul30

Min_No0s

Getting the minimum number from an array excluding zeros. Edit 2025-03-11: ...

2024Jun5

SortArea4

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

2024Apr15

MultiRead_JSON

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

2024Jan13

ANStringListRead_JSON

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

2024Jan9

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

1 2 3 4