Search results 196
Sorted from new to old.

Match5_5thNot0 and Match6_6thNot0
Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

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

ANmAddress_Dimensions
Detects how many dimensions an address has, This is what I call it dimensions ...

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

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

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

Walking Columns (Scrollable Columns-Chart)
Allow users to scroll through columns in column-chart. Used chart.js, this is ...

HTMLTable_FullRow_NonBlanks
Returns all numeric values in row separated by Sepa Only cells that are not ...