get-digital-help.com

Count unique distinct records

Excel » Count unique distinct records »

Count unique distinct records

The image above shows a table with 3 columns containing random data. It is quite complicated trying to manually count […]

Advanced formulas

Based on a condition

Unique distinct values

Join without TEXTJOIN

Lookup & return values

Criteria, two lists

Sums, return unique

Extract missing values

Common values 3 lists

Two price lists

Records in two tables

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

Merge rows - condition

Combine ranges [UDF]

Merge matching rows

Merge 2 cols w. blanks

Consolidate sheets

Merge two columns

Merge 3 columns

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 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

Schedule -> date rngs

Overlapping time

Count overlapping days

Date from week & day

Count overlap. days(2)

Count overlap. days(1)

Overlap. date ranges

Overlapping ranges

Find overlap. ranges

Min/max date overlap.

Date ranges overlap

Consecutive dates

Count overlap days

Prevent overlapping

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

Dates from date rngs

Date rngs from dates

Dates not in rngs

Overlapping ranges

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

No net close to zero

Find numbers in sum

Overlapping time

Count overlapping days

Count overlap. days(2)

Count overlap. days(1)

Overlap. date ranges

Overlapping ranges

Find overlap. ranges

Min/max date overlap.

Date ranges overlap

Count overlap days

Prevent overlapping

Overlap. date ranges

Overlap rngs - condition

Overlapping ranges

Unique strings [UDF]

Sort digits in rng

Based on date criteria

Sort unique A-Z

Min unique number

Sort based on date

Unique distinct values

Uniq. dist. - condition

Adjacent contains string

Adjacent has text

Contains string

Based on criteria

Sorted frequency

Sorted alphabetically

Sorted & no blanks - rng

From a cell range

Sorted A-Z from range

Contains string in rng

Begins with criterion

Based on a date range

Year - month from dates

Based on date criteria

Extract filtered table

Extract & sum condition

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

Dupes from range

Dupes from 3 cols

Dupes from 1 col

Dupes from 2 cols

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

Sort a column A-Z

Sort from 2 cols A-Z

Sort column - frequency

Frequency - criteria

Sort rng - frequency

Sort count freq. condi.

Sort two columns

Sort adj. txt horiz. (1)

Sort table custom

Lookup/Sort custom

Sort random order

Sort based on length

Sort unique A-Z

Sort unique A-Z blanks

Sort cell delimiter [VBA]

Sort Excel table [VBA]

Sort based on proximity

Sort dates - criteria

Vlookup function

VLOOKUP function

Discount percentages

Multiple conditions

Lookup values in rng

Lookup value in rng

Vlookup and return multiple values

Multiple conditions

Sorted from A to Z

Sorted A-Z - condition

Multiple conditions

Vlookup rng - records

Vlook col - return rng

1 result per search

Horizontal vlookup

Vlookup - Drop-down

Multiple sheets

Search and return multiple values

Multiple conditions

Interactive formula

Search for string

Wildcard vlookup

Multiple strings

Criteria - AND logic

Strings in any 2 cols

Strings in 2 cols each

Strings in column

Contains string - column

Extract using criteria

Extract using criteria(2)

Extract using criteria(3)

Recs betw. this & that

Records betw. 2 dates

Date range & condition

Search text string

Filter neg. values

Containing digits

Sort based on freq.

Not shared records

Sort table custom

Records [AND logic]

Records in two tables

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

Count unique distinct records

Duplicate records

Extract duplicate records

<a href="//pixfuture-d.openx.net/w/1.0/rc?cs=45edad9c62&cb=INSERT_RANDOM_NUMBER_HERE" ><img src="//pixfuture-d.openx.net/w/1.0/ai?auid=538803742&cs=45edad9c62&cb=INSERT_RANDOM_NUMBER_HERE" border="0" alt=""></a>

Weekly Blog EMAIL

Get a FREE PDF book!

Welcome! I am Oscar and here to help you out.

Feel free to comment and ask Excel questions.

Make sure you subscribe to my newsletter so you don't miss new blog articles.