Search results 196

  2. Search results
  3. ok
Sorted from new to old.
Card image
ANmaNotMatch

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

2025Apr19
Card image
MatchIf4Up

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

2025Apr12
Card image
ANmaSum_5IFs

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

2025Jan8
Card image
CSS2PDF

Creates pdf from a css/html document. Looking to test it on next project ...

2024Dec20
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
ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10
Card image
RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). The pattern ...

2024Nov10
Card image
ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8
Card image
Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

2024Nov2
Card image
Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

2024Nov1
Card image
ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31
Card image
CountColumnCells_Unique

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

2024Oct6
Card image
Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

2024Sep29
12...1213