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

Formula in cell E2:

=IFERROR(LOOKUP(2, 1/((COUNTIF($A$2:$A$20, $A$2:$A$20)>1)*(COUNTIF($E$1:E1, $A$2:$A$20)=0)*(COUNTIF($C$2:$C$3, $A$2:$A$20)<>1)), $A$2:$A$20), "")

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

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:

5 easy ways to extract unique distinct values

Update: 30 Aug, 2017 You have quite a few options to choose from if you are looking for a way […]

Comments(149) Filed in category: Advanced filter, Excel, Unique distinct values, Unique values

Download excel *.xlsx file

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