Search results 167

Sorted from new to old.

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

2025Aug7

JSon_Read_aText

Reads all json files generated by aText Sync command (screenshots) from certain ...

2025Jul27

CutString_JsonKeyValue

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

2025Jul27

Calculation_StaleValues

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

2025Jun30

ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

2025May16

MatchIf8Up

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

2025May7

MatchIf7Up

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

2025May3

MatchIf7

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

2025May2

ANmaNotMatch

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

2025Apr19

FirstDuplicatedItem

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

2025Apr18

MatchIf4Up

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

2025Apr12

TemplateLine_10Xs

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

2025Mar16

VBInstr_SpaceFriends_BetweenHTMLTags

Searches for string inside string with multiple possibilities, returns ...

2025Mar13

ToggleCells

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

2025Feb2

Toggle5Values

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

2025Feb2

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

2025Jan8

1 2 ...10 11