Search results 87

Sorted from new to old.

ANStrVLookupAll

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

Sat 4PM

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

ANStrSort2

Sorting items inside ANStr, this one in ASP Classic (VBScript) Like the VBA ...

May25

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

HTMLTable_NoOfColumns

Gets no of columns in an HTML table. It actually gets the maximum number of ...

2024Oct26

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

RoundUp2

Rounds a number to nearest identifier up. Like 105 up to nearest 20 ...

2024Oct1

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

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

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

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

2024Jan17

ImgDimensions

Reads image dimensions, width, height, depth and image type. Details returned ...

2024Jan16

1 2 ...5 6