Search results 64

Sorted from new to old.

VBInstr_Any

Search for string inside another, with ability to have multiple strings to ...

Fri 5AM

ANmaSum_4IFs

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

Nov13

Match5_5thNot0 and Match6_6thNot0

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

Nov13

ConditionalFormatting_ColorARow

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

Nov10

RegExPatternMatch

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

Nov10

Match3_3rdNot0

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

Nov2

Match4_4thNot0

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

Nov1

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

Sep24

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

Aug11

FindZipFile_WShell

Finds the first zip in a folder matching wild cards mask using WScript.Shell ...

Aug2

FindImg_WShell

Finds the first image in a folder matching wild cards mask using WScript.Shell ...

Jul31

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

Jul13

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6

MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

May31

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May31

MatchIf5Up

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

May27

1 2 3 4