Search results 117

Sorted from new to old.

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

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

MatchIf2Up

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

Apr29

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Apr15

MatchIfUp or MatchIfRev

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

Apr8

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Mar14

FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

Mar4

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

Feb20

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

Feb18

VLookup_HTML

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

Jan26

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Jan20

MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

Jan13

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

1 2 ...7 8