Search results 60

Sorted from new to old.
Card image
VBInstr_Any

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

Card image
ANmaSum_4IFs

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

Card image
Match5_5thNot0 and Match6_6thNot0

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

Card image
RegExPatternMatch

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

Card image
Match3_3rdNot0

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

Card image
Match4_4thNot0

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

Card image
ANmAddressSame

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

Card image
ANmaRead_1stFile

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

Card image
FindZipFile_WShell

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

Card image
FindImg_WShell

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

Card image
ANmaReplace_Occurrence

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

Card image
JSON_To_Table

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

Card image
MatchIf6Up

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

Card image
MatchIf6

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

Card image
MatchIf5Up

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

Card image
ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion