Records

Advanced formulas

Concatenate

Based on a condition

Unique distinct values

Drop-down list

Join without TEXTJOIN

Lookup & return values

Compare

Criteria, two lists

Sums, return unique

Extract missing values

Common values 3 lists

Two price lists

Records in two tables

Common records

Update recent values(2)

Missing values two cols

Update recent values

Values shared by 2 rngs

Vals not shared 2 rngs

Values shared by 3 rngs

Extract not shared vals

Shared values 2 cols

Missing values 2 cols

Combine merge

Merge tables

Merge rows - condition

Combine ranges [UDF]

Merge matching rows

Merge 2 cols w. blanks

Pattern in cell value

Overlapping time

Containing any list value

Unique distinct/condition

Count colored cells

Equal values per row

Count overlapping days

Sort count freq. condi.

Count overlap. days(2)

Count overlap. days(1)

Contiguous values

Count Conditionally Formatted cells

Count based on color

Count filtered table

Groups of each value

Weekday in date range

Weekday date range(2)

Cells between value

Entries date & time rng

Unique distinct - criteria

Unique dist. rec. criteria

Digits - no duplicates

Based on criteria

Count groups in calendar

Uniq. dist. based dates

Count based on date

Numbers across sheets

Cells between values

Most freq/date range

Unique distinct months

Uniq. dist. 2 cols

Unique dist. values

Dates

Schedule -> date rngs

Overlapping time

Count overlapping days

Date from week & day

Count overlap. days(2)

Count overlap. days(1)

Min/max date overlap.

Find date range based on a date

Create date ranges

Weekday in date range

Calc dates in project

Weeks from ranges

Weekday date range(2)

Entries date & time rng

Overlap. date ranges

Overlap rngs - condition

Count groups in calendar

Dates from overlap rngs

Based on date criteria

Date, week, month

Dupes - date, wk, month

Year - month from dates

Match date in date rng

Latest date - condition

Most freq/date range

Find min/max date rng

Blank between quarters

Dupe vals sorted date

Create date range

Lookup the nearest date

Based on a date range

Machine utilization

Date based on wkday

Find numbers in sum

Numbers closest to sum

Count overlapping days

Count overlap. days(2)

Count overlap. days(1)

Min/max date overlap.

Overlap rngs - condition

Based on date criteria

Unique distinct values

Uniq. dist. - condition

Adjacent contains string

Sorted alphabetically

Sorted A->Z

Sorted & no blanks - rng

Sort length

From a cell range

Sorted A-Z from range

Contains string in rng

Begins with criterion

Based on a date range

Based on dates

Year - month from dates

Based on date criteria

Extract filtered table

Extract & sum condition

Two conditions

Sum uniq. dist. rec.

Assign randomly unique

Sums, return unique

Sorted, no blanks - rng

Duplicate values

Dupes A-Z condition

Dupes w. exceptions

Filter duplicate values using critera

Common values 3 lists

Label duplicate records

Dupes - date, wk, month

Dupes from rng contain

Filter dupes begins w.

Min unique number

Dupe vals sorted date

Create a list of duplicates where adjacent cell value meets a condition

Sort column - frequency

Frequency - criteria

Sort rng - frequency

Sort count freq. condi.

Sort two columns

Sort records

Sort table

Sort adj. txt horiz. (1)

Sort unique A-Z blanks

Sort cell delimiter [VBA]

Sort Excel table [VBA]

Sort based on proximity

Sort dates - criteria

Vlookup and return multiple values

5 easy ways

Multiple conditions

Sorted from A to Z

Sorted A-Z - condition

Multiple conditions

Vlookup range

Vlookup rng - records

Vlook col - return rng

Search and return multiple values

Strings in any 2 cols

Strings in 2 cols each

Strings in column

Contains string - column

Filter records

Extract using criteria

Extract using criteria(2)

Extract using criteria(3)

Recs betw. this & that

Records betw. 2 dates

Date range & condition

Records in two tables

Unique records

Common records

Duplicate columns

Unique distinct records

Extract unique distinct records from two data sets

Sort based on freq.

Filter unique distinct records using criteria

Count uniq. dist. [2010]

Unique dist. rec. criteria

Records - condition(2)

Records - condition(1)

Filter unique distinct records

Count unique distinct records

Duplicate records

Extract duplicate records

Count records

Excel » Records »

Unique distinct records sorted based on count or frequency

Sara asks: How can you use large with multiple criteria?? Example looking for top 5 of a list based on […]

Remove common records between two data sets

This article demonstrates how to filter records occurring in only one out of two Excel defined tables. It also shows […]

How to sort a data set in a custom order

Your boss wants you to sort the company's products by a new criterion, quality. You receive a list from your […]

Highlight records [AND logic]

The picture above shows you conditional formatting formula that highlights matching records based on criteria in row 3 and 4. […]

Compare tables: Filter records occurring only in one table

In this example we are going to use two lists with identical columns, shown in the image above. It is […]

Compare tables: Highlight records not in both tables

The image above demonstrates a conditional formatting formula that highlights records that only exist in one table. There are two […]

Compare two lists of data: Highlight common records

In this blog post I will demonstrate a conditional formatting formula that will highlight common records in two lists. The […]

Filter shared records from two tables

I will in this blog post demonstrate a formula that extracts common records (shared records) from two data sets in […]

Highlight duplicate columns

This article describes how to highlight duplicate records arranged into a column each, if you are looking for records entered […]