Search results 142

Sorted from new to old.

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

Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

Mar4

UniqueRandomID in SQL

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

Feb18

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

Feb8

SQL Cross Apply String_Split with XML Path

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

Jan20

HTMLPadding_or_Margin

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Jan5

ReNumber_IDColumn_inTable

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

2023Dec17

ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27

ANmaFilter3

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

2023Oct13

Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

2023Sep20

1 2 ...8 9