Search results 120

Sorted from new to old.

MatchIF5

Searching for rows having 5 values in 5 columns Like

2024May6

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

2024Apr30

MatchIf2Up

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

2024Apr29

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

2024Apr23

MatchIfUp or MatchIfRev

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

2024Apr8

ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

2024Apr3

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

2024Mar2

HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

2024Feb28

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

2024Feb25

EdgarCIK

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

2024Feb25

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

2024Feb3

HTMLTagID_Previous

Return id for any html tag that was found above certain location of html page. ...

2024Feb2

NumberBeforeString_HTML

Cuts a number that would be found before certain word inside a block string. ...

2024Feb1

VLookup_HTML

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

2024Jan26

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

2024Jan24

1 2 3 ...7 8