Search results 18

Sorted from new to old.

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

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

MatchIf2Up

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

Apr29

MatchIfUp or MatchIfRev

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

Apr8

EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

Feb25

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Jan26

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

MatchLastIf

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

2019Jun12

VBInstr (or Instr parameters)

The great function InStr I use a lot has a small confusing part. Which string ...

2019Jan9

CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

2018Jun26

1 2