Search results 60

Sorted from new to old.

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

2018Jul9

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

2018Jul4

Sorts a column in Excel, easily, with options

2018Jul4

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

2018Jun30

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

2018Jun25

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

2018Jun24

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

2018Jun22

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

2018Jun16

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

2018Jun16

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

2018Apr23

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

2018Apr21

This script will replace single quotes so the data is SQL-safe

2018Apr16