Search results 148

Sorted from new to old.

Tabs-Auto-To-Menu

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

Sun 6AM

MatchIf7Up

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

Sat 8AM

MatchIf7

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

Fri 1PM

MatchIf4Up

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

Apr12

DB Connection Drivers Test

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

Mar12

CutString_ANmaRules

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

Feb26

ANmaRemoveDuplicates2

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

2024Dec4

ANmaRemoveDuplicates4

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

2024Dec4

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

ConditionalFormatting_ColorARow

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

2024Nov10

Sheet_RowID_Generate + _LastUsed

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

2024Nov3

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

2024Nov1

HTMLTable_NoOfColumns

Gets no of columns in an HTML table. It actually gets the maximum number of ...

2024Oct26

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

2024Sep29

Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

2024Sep5

1 2 ...9 10