Search results 128

Sorted from new to old.

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1

RoundMinutes

Rounds time into nearest quarter up or down, half up or down based on argument ...

2019Jan9

VBInstr (or Instr parameters)

The great function InStr I use a lot has a small confusing part. Which string ...

2019Jan9

Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...

2018Oct1

ArrSort_2Arr

Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...

2018Oct1

AmIMobile

Check if browser is for a mobile or tablet, or not. This was before we have ...

2018Aug8

ProtectText + UnProtectText

Encrypt or decrypt text, simple encryption with a numeric password Decrypt a ...

2018Jul19

Active BS4 breakpoint

Was looking for some way to show bootstrap 4 breakpoint, and got this. Needs ...

2018Jul6

PI

Returns a double representing the mathematical constant Pi

2018Jul5

Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

2018Jun30

TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26

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

CreateGUID

Generate random GUID of 36 chars (with or without brackets) using TypeLib ...

2018Jun25

CellHyperlink_ToSheet

Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...

2018Jun24

File_FirstFound

Gets first file found matches a wildcards mask, using Dir()

2018Jun20

1 2 ...7 8