Oscar Cronquist

Create a number sequence in Excel

Count unique distinct records [Formula]

Count unique distinct values [Formula]

Filter records between this and that [Array Formula]

Copy/Rename/List files in a folder

Remove Print Preview Lines [VBA]

Return all combinations

Create Links To All Sheets in a Workbook

Create a Print button

Match a date within unsorted noncontigous date ranges

Match a date when a date range is entered in two cells

Formula for matching a date within a date range

Lookup multiple values in different columns and return a single value [Array Formula]

Sum values in a range where adjacent cell value equals a criterion [Array Formula]

Extract a unique distinct list by matching items that meet a criterion [Array Formul]

Run a macro from a drop down list [VBA]

Vlookup a cell range and return multiple values

Get the corresponding value from the latest date using a condition

Lookup all values and find latest date

Lookup value and return latest date [Formula]

Working with Combo Boxes [VBA]

Lookup and return multiple values concatenated into one cell - Wildcard Search

Lookup and return multiple values concatenated into one cell - Delimiting character

Lookup and return multiple values concatenated into one cell - Ignore duplicates

Lookup and return multiple values concatenated into one cell [User Defined Function]

Lookup and return multiple values concatenated into one cell

Use VLOOKUP and return multiple values sorted from A to Z

Vlookup – Return multiple unique distinct values

Extract a unique distinct list from two columns [Formula]

How to use a Table name in Data Validation Lists and Conditional Formatting formulas