Search results 202

Sorted from new to old.

CopyRange_NoClipboard

Copies range without using clipboard. Applies formats into a cell (or range) ...

2018Aug10

Posts_per_Year

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

2018Jul29

RandomRecords

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

2018Jul29

DegreeC2K

Convert a Celsius temperature to a Kelvin temperature. To convert Fahrenheit ...

2018Jul25

doHighlight

Search for occurrences of a keyword in a string and highlight them, by either ...

2018Jul19

RGB2HTML + HTML2RGB

Converts RGB color to / from HTML format As bonus, functions RGB_ExtractColor ...

2018Jul9

SplitTo2DArray

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

2018Jul9

FixENTERS_File

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

2018Jul7

SortArea5

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

2018Jul5

SortArea3

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

2018Jul4

SortArea1

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

2018Jul4

Sort1Col

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

2018Jul4

DegreeC2F + DegreeF2C

Convert Celsius to Fahrenheit and Fahrenheit to Celsius degrees

2018Jul3

FormulasFlatten

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

2018Jun30

SettingRead_JR

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

2018Jun26

CellRead (SimpleLookup)

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

2018Jun25

1 2 ...11 12 13