## Extract duplicate values with exceptions

The formula in cell E2 returns duplicate values from column A but values in column C are excluded from the list.

**Array formula in cell E2:**

This post explains how to extract duplicate values using a condition:

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

Question: How do I filter duplicates with a condition? Answer: Column B contains category and column C contains Items. Only […]Comments(0) Filed in category: Duplicate values, Excel

You can also use more than one condition, this article shows you how:

Filter duplicate values using critera

The following worksheet allows you to search for duplicate names using a date range (cell B1 and B2) and a […]Comments(0) Filed in category: Duplicate values, Excel

If you want a list sorted from A to Z, read this article:

Extract a list of alphabetically sorted duplicates from a column in excel

Question: How do I create a new list of alphabetically sorted duplicates using excel array formula? Answer: Excel array formula […]Comments(1) Filed in category: Duplicate values, Excel, Sort values

Filter a unique distinct list:

How to extract a unique distinct list from a column in excel

You have quite a few options to choose from if you are looking for a way to create a unique […]Comments(149) Filed in category: Advanced filter, Excel, Unique distinct values

#### How to enter an array formula

- Copy (Ctrl + c) above formula
- Double click on cell E2
- Paste (Ctrl + v) to cell E2
- Press and hold CTRL + SHIFT simulatneously
- Press Enter once
- Release all keys

Your formula now looks like this: {=array_formula}

Don't enter the curly brackets, they appear automatically.

Learn the basics of Excel arrays

Array formulas allows you to do advanced calculations not possible with regular formulas.Comments(2) Filed in category: Built-in features, Count values, Excel

#### Download excel *.xlsx file

how-to-extract-a-list-of-duplicates-from-a-columns-in-excel_version2.xlsx