MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

MinIF and MaxIF in Excel 2010

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

MaxIF_MinIF_byNMR.zip

VBInstr (or Instr parameters)

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

Files_MostRecentN

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

ArrSort_2Arr

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

AmIMobile

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

TextPercentageMatch

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

SettingRead_JR

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

CellRead (SimpleLookup)

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

File_FirstFound

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

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...