Search results 22

Sorted from new to old.

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

CountColumnCells_Unique

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

2024Oct6

CountRowCells

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

2024Jun22

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

2024Feb25

Nearby Color shades

Calculate colors close to input color, a jquery html that will give you 10 ...

2023Nov8

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25

Column1Range

Return range of cells in column having data where, ignoring header cell and ...

2023Oct7

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

2021Nov26

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

Tabs24-BS3

Nice elegant tabs in bootstrap 3

2019Apr27

1 2