Search results 153

Sorted from new to old.
Card image
DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

Card image
Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

Card image
BoldCodeColor

Bold the first letter and color it based on Bootstrap color theme, info, ...

Card image
MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

Card image
MatchIf8Up

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

Card image
Tabs-Auto-To-Menu

Turns tabs into menu based on available width. JS (Bootstrap 5) code to turn ...

Card image
MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

Card image
MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

Card image
MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

Card image
DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Card image
CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

Card image
ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

Card image
ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

Card image
ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Card image
ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

Card image
Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...