Search results 109

Sorted from new to old.

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

Thu 11AM

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Oct6

RegSave, RegRead, RegDelete

Windows Registry read, save and delete branch node or key. Three functions use ...

Sep15

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

Sep3

Choose2

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

Aug20

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

Aug7

ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

Jul26

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

Jun1

MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

May31

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

Mar4

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

Mar2

ANmaRemoveNestedTags

Remove tags that are identical and nested inside each other in an HTML document, ...

Feb4

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Jan26

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

1 2 ...6 7