Search results 239

Sorted from new to old.

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

Jul27

Icon as text - CmdCaption_ChrW

Creates an icon as text to use inside button or any frm20 controls. this will ...

Jul17

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

1 2 ...14 15