Search results 9

Sorted from new to old.
Card image
MatchIf6

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

Card image
MatchIF5

Searching for rows having 5 values in 5 columns Like

Card image
Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

Card image
MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

Card image
CreateGUID

Generate random GUID of 36 chars (with or without brackets) using TypeLib ...

Card image
InvertColor

Converts color into its negative value, as in "e4f15a" into "1C0FA6"

Card image
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

Card image
Match2

Matching by two values at the same time in two columns Just like Match the ...

Card image
MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...