Search results 72

Sorted from new to old.

HasDups

Indicates if an array contains duplicate values. returns True if more than one ...

2019Oct5

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output as string. ...

2019Jun28

MatchLastIf

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

2019Jun12

MinIF and MaxIF in Excel 2010

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

2019Feb1

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

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

File_FirstFound

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

2018Jun20

MatchIf_ThenDelete

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

2018Jun17

Match4

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

2018Jun16

Match3

Matching three values at the same time in three columns Just like Match the ...

2018Jun16

1 2 3 4 5