Search results 59

Sorted from new to old.

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

Nov3

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

Sep3

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Aug20

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

Aug7

MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

May31

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

Jan30

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

Jan14

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27

Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

BrowserSetting

Detect Browser setting (type or other info) using MSWC.browsertype object. Old ...

2022Apr29

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

1 2 3 4