Search results 163

Sorted from new to old.

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

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

String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

Apr10

ANmaHideIntoJPG and ANmaExtractFromJPG

Hide files into jpg and restore it using those two functions. Attached file ...

Apr2

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

ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

Jan12

ANmaSum_5IFs

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

Jan8

Match6_Until

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

2024Nov28

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

2024Nov13

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

SettingRead_Bulk

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

2024Nov3

1 2 ...10 11