Search results 70

Sorted from new to old.
Card image
SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

Card image
ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

Card image
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Card image
HasDups

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

Card image
Rows 2 Cell

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

Card image
ProfileBadge_Linkedin

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

Card image
MinIF and MaxIF in Excel 2010

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

Card image
VBInstr (or Instr parameters)

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

Card image
Files_MostRecentN

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

Card image
TextPercentageMatch

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

Card image
SettingRead_JR

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

Card image
CellRead (SimpleLookup)

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

Card image
File_FirstFound

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

Card image
MatchIf_ThenDelete

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

Card image
Match4

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

Card image
Match3

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