Search results 60

Sorted from new to old.
Card image
Pagination call

How to read certain page from SQL table Originally from from http://social. ...

Card image
SplitTo2DArray

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

Card image
SortArea3

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

Card image
Sort1Col

Sorts a column in Excel, easily, with options

Card image
FormulasFlatten

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

Card image
CellRead (SimpleLookup)

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

Card image
RowsCount

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

Card image
CellRead

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

Card image
HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

Card image
SettingRead+SettingSave

This is the final version of my set of Setting functions SettingRead, ...

Card image
DB_AllRows

Returns all rows found from an SQL Query as string Separated by row and column ...

Card image
DB_Read1Row (DB_Read1stRow)

Reads from a table in a DB Reads only the first row, and return a string ...