Search results 67

  2. Search results
  3. matching
Sorted from new to old.
Card image
ProfileBadge_Linkedin

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

2019Jun28
Card image
MatchLastIf

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

2019Jun12
Card image
MinIF and MaxIF in Excel 2010

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

2019Feb1
Card image
VBInstr (or Instr parameters)

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

2019Jan9
Card image
Files_MostRecentN

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

2018Oct1
Card image
TextPercentageMatch

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

2018Jun26
Card image
SettingRead_JR

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

2018Jun26
Card image
CellRead (SimpleLookup)

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

2018Jun25
Card image
File_FirstFound

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

2018Jun20
Card image
MatchIf_ThenDelete

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

2018Jun17
Card image
Match4

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

2018Jun16
Card image
Match3

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

2018Jun16
Card image
Match2

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

2018Jun16
Card image
HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16
Card image
MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16
Card image
DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

2018May31
12345