Search results 187

  2. Search results
  3. Val
Sorted from new to old.
Card image
MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

May10
Card image
MatchIf8Up

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

May7
Card image
MatchIf7Up

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

May3
Card image
MatchIf7

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

May2
Card image
ANmaNotMatch

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

Apr19
Card image
FirstDuplicatedItem

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

Apr18
Card image
MatchIf4Up

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

Apr12
Card image
TemplateLine_10Xs

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

Mar16
Card image
ToggleCells

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

Feb2
Card image
Toggle5Values

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

Feb2
Card image
ANmaSum_5IFs

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

Jan8
Card image
VBInstr_Occurance

Returns location of text inside another with jump ability for any certain ...

2024Dec1
Card image
Match6_Until

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

2024Nov28
Card image
Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

2024Nov22
Card image
ANmaSum_4IFs

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

2024Nov13
Card image
Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

2024Nov13
12...1112