Author: Oscar Cronquist Article last updated on September 19, 2017

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 [โฆ]

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 [โฆ]

Extract a list of alphabetically sorted duplicates from a column

The following array formula extracts duplicate values sorted from A to Z from cell range B3:B21. Excel array formula in [โฆ]

Filter a unique distinct list:

5 easy ways to extract Unique Distinct Values

First, let me explain the difference between unique values and unique distinct values, it is important you know the difference [โฆ]