Search results 144

  2. Search results
  3. base
Sorted from new to old.
Card image
DB Connection Drivers Test

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

Mar12
Card image
CutString_ANmaRules

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

Feb26
Card image
ANmaRemoveDuplicates2

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

2024Dec4
Card image
ANmaRemoveDuplicates4

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

2024Dec4
Card image
ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18
Card image
ConditionalFormatting_ColorARow

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

2024Nov10
Card image
Sheet_RowID_Generate + _LastUsed

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

2024Nov3
Card image
Match4_4thNot0

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

2024Nov1
Card image
HTMLTable_NoOfColumns

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

2024Oct26
Card image
CleanArray_2Dim

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

2024Oct24
Card image
Font-Based progress bar

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

2024Sep29
Card image
Choose20

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

2024Sep5
Card image
Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

2024Sep3
Card image
Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20
Card image
ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11
Card image
CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

2024Jun22
12...89