Search results 14

Sorted from new to old.

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

Oct6

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

Jun22

Counts how many cells matching 2 criterias. Just like

May1

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

2023Oct30

Return a range of cells in column where ... Return Range Ignore header ...

2023Oct7

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

2022Apr26

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

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

2021Dec30

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

2021Nov26

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

2021Nov26

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

2018Jun16

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23