Excel – Unique and duplicate values
Unique values
Introduction to unique values
Unique values are values existing only once in a list or range. See picture below.
Column
How to extract a unique list from a column in excel
Filter unique rows and sort by date using array formula in excel
Min and max unique and duplicate values using array formula in excel
Sum only if unique value in another column in excel
Two columns
Create unique list from two columns
Comparing two columns and sum unique values using array formula in excel
Three columns
No blog articles yet.
Range
Extract unique values from a range using array formula in excel
Unique distinct values
Introduction to unique distinct values
Unique distinct values are all values in a range or column but duplicates are merged into one distinct value. Duplicate values are removed.
Column
Create a unique distinct alphabetically sorted list, extracted from a column
How to automatically create a unique distinct list and remove blanks
How to extract a unique distinct list from a column in excel
Create and sort distinct list by adjacent cell value size
Min and max unique and duplicate values using array formula in excel
Create unique distinct list sorted based on text length using array formula in excel
Unique distinct list sorted based on occurrance in a column in excel
Unique distinct list from a column sorted A to Z using array formula in excel
How to create a unique distinct list where other columns meet two criteria
Create a list of distinct values from a list where an adjacent cell value meets a criteria in excel
Lookup Unique based on Multiple Conditions
Unique list to be created from a column where an adjacent column has text cell values
Create a unique distinct list and sort by occurrances from large to small
Create unique distinct list from column where an adjacent column meets criteria
Min and max unique and duplicate values using array formula in excel
Two columns
Create unique distinct list from two columns
Extract a unique distinct list from two columns using excel 2007 array formula
Three columns
Extract a unique distinct list from three columns in excel
Range
Unique values from multiple columns using array formulas
Extract a unique distinct list sorted from A-Z from range in excel
Filter unique distinct values from two ranges combined in excel 2007
Extract a unique distinct list sorted alphabetically removing blanks from a range in excel
Automatically filter unique row records from multiple columns
Duplicate values
Column
How to extract a list of duplicates from a column in excel
Extract a list of alphabetically sorted duplicates from a column in excel
Filter duplicate rows and sort by date using array formula in excel
Identify duplicate invoice records in excel
Create a list of duplicates where adjacent cell value meets a condition in excel
How to create an array of uniquely ranked duplicate values in excel
Show duplicates and their adjacent values
Two columns
Filter duplicates from two columns combined and sort from A to Z using array formula in excel
Extract a list of duplicates from two columns combined using array formula in excel
Extract a list of duplicates from a column using array formula in excel
Three columns
Extract a list of duplicates from three columns combined using array formula in excel
Range
Extract duplicates from a range using excel 2007 array formula
How to find duplicates in a range spanning multiple columns?
Dates
Filter duplicate rows and sort by date using array formula in excel
Extract distinct unique sorted year and month list from a date series in excel
Create a unique distinct list from a date range in excel
Conditional formatting
Highlight unique distinct values in two ranges combined using conditional formatting in excel
Highlight smallest duplicate value in a column using conditional formatting in excel
Highlight duplicate values in a range using conditional formatting in excel
Highlight unique values and unique distinct values in a range using conditional formatting in excel
Identify duplicate invoice records using conditional formatting in excel
Highlight duplicates where adjacent cell value meets criteria using conditional formatting in excel
Conditional formatting highlights more than 10 if there are duplicates
Count unique and unique distinct values
How to count unique distinct records in a date range
How to create a unique list using conditional formatting in excel 2007
Count unique and unique distinct values in a multicolumn range in excel
Count unique distinct values in two columns with date criteria in excel
Count unique distinct values in three columns combined in excel
Count unique distinct values in two columns in excel
Count unique distinct values in a column in excel
How to count unique combined column values
Misc
A more userfriendly version of: Automatically filter unique row records from multiple columns
[…] column data of unique entries. May be you can understand what i want as a formula to look this... Excel - Unique and duplicate values | Get Digital Help Many thanks and […]