Oscar Cronquist

Concatenate values in a cell range [No VBA]

Create Links To All Sheets in a Workbook

VLOOKUP and return multiple values [UDF]

Find numbers in sum [Excel Solver]

Concatenate cell values in a column [No VBA]

Match a date within unsorted noncontigous date ranges

Count unique distinct records [Formula]

Copy/Rename/List files in a folder

Return value if in range - LOOKUP function [Excel Formula]

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

Count unique distinct values [Formula]

Extract duplicate values from a column [Formula]

Filter unique distinct values from multiple sheets [Add In]

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

Run a macro from a drop down list [VBA]

Create a unique distinct alphabetically sorted list extracted from a column [Array Formula]

Get the corresponding value from the latest date using a condition

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

Search for a text string and return multiple adjacent values [Array Formula]

Extract a unique distinct list from two columns [Formula]

Filter records between this and that [Array Formula]

Formula for matching a date within a date range

Create a Print button

Count unique distinct values meeting criteria [Array Formula]

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

Remove Print Preview Lines [VBA]

Concatenate values in a cell range [No VBA]

Vlookup a cell range and return multiple values

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

Auto refresh a pivot table [Excel Macro]