Codes Required

Similar codes

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

Card image cap
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Apr8

Card image cap
Match2

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

2018Jun16

Card image cap
MatchIf5Up

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

May27

Card image cap
HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16

Card image cap
ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

Jul2

Card image cap
HTML5 tags cheatsheet

A simple graphic illustrates the new HTML5 tags and differences against old ones

2021Apr16

Card image cap
MatchIf6Up

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

May31

Card image cap
ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

Oct13

Recently by developer

Card image cap
ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

Sat 3PM

Card image cap
ANmaReplace_Occurrence

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

Sat 8AM

Card image cap
ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Sat 7AM

Card image cap
ANmaSearch_AposFriends

Searches for string inside string with apostrophe possibility (or as I call ...

Thu 7AM

Random Codes

Card image cap
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

Card image cap
Shortcut website

Create a shortcut to website to open using Internet Explorer in 'InPrivate' ...

2020Jan22

Card image cap
myURLDecode

Decode a URL, opposite of Server.URLEncode

2018Jul15

Card image cap
RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22