Search results 82

Sorted from new to old.

CutString_JsonKeyValue

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

Jul27

Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

Jun30

MatchIf7Up

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

May3

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

May2

ANmaNotMatch

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

Apr19

MatchIf4Up

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

Apr12

TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

Mar16

ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2

Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

Feb2

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

CountColumnCells_Unique

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

2024Oct6

RegSave, RegRead, RegDelete

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

2024Sep15

Choose10

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

2024Sep3

Choose2

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

2024Aug20

HTMLTable_FullRow_NonBlanks

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

2024Aug7

1 2 ...5 6