Search results 159
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 ...
Showing 4k (and more) images in BS5 modal
Allow users to browse and scroll through tons of images to select one (tried on ...
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 ...
HTMLTable_FullRow_NonBlanks
Returns all numeric values in row separated by Sepa Only cells that are not ...
HTMLTable_FullRow
Returns full row from RowID ... the full area between < tr ...> and < /tr> from ...
ANmAdd_ThenSort_2Columns
Adds values of 2 cells into 2 columns (usually below them). I used these small ...