Search results 167

Sorted from new to old.
Card image
Create Tree from 3 columns (Sheet2Tree)

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

Card image
JSon_Read_aText

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

Card image
CutString_JsonKeyValue

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

Card image
Calculation_StaleValues

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

Card image
ANmaRemoveMultiSpace

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

Card image
MatchIf8Up

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

Card image
MatchIf7Up

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

Card image
MatchIf7

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

Card image
ANmaNotMatch

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

Card image
FirstDuplicatedItem

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

Card image
MatchIf4Up

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

Card image
TemplateLine_10Xs

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

Card image
VBInstr_SpaceFriends_BetweenHTMLTags

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

Card image
ToggleCells

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

Card image
Toggle5Values

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

Card image
ANmaSum_5IFs

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