Search results 142

  2. Search results
  3. Column
Sorted from new to old.
Card image
Posts_per_Year

Gets list of years and total of posts per year from a table, by using date ...

2018Jul29
Card image
RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29
Card image
SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9
Card image
FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7
Card image
SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5
Card image
SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

2018Jul4
Card image
SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4
Card image
Sort1Col

Sorts a column in Excel, easily, with options Expects ... Row 1 is header, ...

2018Jul4
Card image
FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30
Card image
SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26
Card image
CellRead (SimpleLookup)

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

2018Jun25
Card image
LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24
Card image
RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22
Card image
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17
Card image
CellRead

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

2018Jun16
Card image
Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

2018Jun16
12...89