Search results 237

Sorted from new to old.

ANStrVLookupAll

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

Jun14

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

Jun14

DBTableCol_Array

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

May30

ANmaSearch_AnyWord_FromANStr

Checks if string has any word from ANStr inside it Unlike

May26

FilesIn_4Array

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

May25

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

May12

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

May12

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

May10

MathInsideText

Return string after applying math to each number found inside the string. ...

May8

MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

May7

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

May3

ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

Apr19

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

Apr18

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

Apr12

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

Apr11

NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

Apr10

1 2 ...14 15