Search results 11

  2. Search results
  3. columnname
Card image cap
HMatchIf_Multi

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

2023Oct30
Card image cap
Column1Range

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

2023Oct7
Card image cap
CreateUniqueList

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

2022Apr26
Card image cap
DynamicFill

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

2022Mar11
Card image cap
IsError_Range

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

2021Dec30
Card image cap
GetColumnIndex

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

2021Nov26
Card image cap
Subtotal_Indirects

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

2021Nov26
Card image cap
CellRead (SimpleLookup)

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

2018Jun25
Card image cap
CellRead

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

2018Jun16
Card image cap
GetColumnName, ColumnName_XOffset

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

2018Jun15
Card image cap
CountColumnCells + CountColumnCells_Criteria

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

2018May23