Search results 1,045

Sorted from new to old.

Sheet_RowID_Generate + _LastUsed

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

2024Nov3

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

2024Nov2

Match4_4thNot0

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

2024Nov1

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31

GetPapa + GetSon with variances

Gets the parent folder full name from a path Also Gets the son of a full path. ...

2024Oct26

HTMLTable_NoOfColumns

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

2024Oct26

MaxOfArray

Gets the maximum number from an array. Like

2024Oct24

HTMLCloseTag_HasWordAfter

Finds the number of occurrence of a "Numeric" inside a string having a certain ...

2024Oct6

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

RoundUp2

Rounds a number to nearest identifier up. Like 105 up to nearest 20 ...

2024Oct1

Walking Columns (Scrollable Columns-Chart)

Allow users to scroll through columns in column-chart. Used chart.js, this is ...

2024Sep30

Font-Based progress bar

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

2024Sep29

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

2024Sep24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

2024Sep21

1 2 ...4 ...65 66