## Easily identify groups of duplicate rows

**Michael asks:**

I need to identify the duplicates based on the Columns D:H and put in Column C a small “d” + a running number for the duplicates which are duplicated the same.

If no duplicates only to put in a “d0” for instance.

**Answer**

**Array formula in cell B3:**

**How to create an array formula**

- Double click cell B3
- Copy/Paste above formula
- Press and hold Ctrl + Shift
- Press Enter

**How to copy array formula**

- Select cell B3
- Copy (Ctrl + c)
- Select cell range B4:B11
- Paste (Ctrl + v)

**Download excel 2007 *.xlsx file**

### Category: Duplicate values

The array formula in cell C2 extracts duplicate values from column A. Only one duplicate of each value is displayed […]

Comments(41) Filed in category: Duplicate values, Excel

Question: I have three ranges or lists and I need to extract duplicates from those ranges combined using excel array […]

Comments(7) Filed in category: Duplicate values, Excel

In this post I am going to describe how to filter duplicate and unique distinct values from a really large […]

Comments(4) Filed in category: Case sensitive, Duplicate values, Excel, Unique distinct values

Question: How do I get the largest and smallest unique and duplicate value? Answer: Max duplicate value, formula in C22: […]

Comments(4) Filed in category: Duplicate values, Excel, Unique values

Question: Column A1 Has dates Column B as data A1 : 1/1/2010 : 5000 A2 : 2/1/2010 : 4000 A3 […]

Comments(3) Filed in category: Dates, Duplicate values, Excel, Unique distinct values

Aamer asks: I have a sheet with 3000 rows of invoice dates that are out of order. There could be […]

Comments(3) Filed in category: Duplicate values, Excel, Unique distinct values, User defined functions (udf), VBA

Filter duplicates on same date Array formula in F3: =INDEX($C$3:$C$11, SMALL(IF(MATCH($C$3:$C$11&$D$3:$D$11, $C$3:$C$11&$D$3:$D$11, 0)<>ROW($C$3:$C$11)-MIN(ROW($C$3:$C$11))+1, ROW($C$3:$C$11)-MIN(ROW($C$3:$C$11))+1, ""), ROW(A1))) + CTRL + SHIFT […]

Comments(2) Filed in category: Dates, Duplicate values, Excel

Question: I have two ranges or lists where I want to extract duplicates? Answer: Excel 2007 formula in D2: =IFERROR(IFERROR(INDEX(List1, […]

Comments(2) Filed in category: Duplicate values, Excel

AJ Serrano asks: I have a column where each rows contains different values and I wanted to obtain the duplicate […]

Comments(2) Filed in category: Duplicate values, Excel, User defined functions (udf), VBA

This blog post describes how to extract duplicates sorted from A to Z from two different columns combined. Array formula […]

Comments(2) Filed in category: Combine/Merge, Duplicate values, Excel, Sort values

### One Response to “Easily identify groups of duplicate rows”

### Leave a Reply

**How to add a formula to your comment:**

<code>your formula</code>

**How to add VBA code to your comment:**

[vb 1="vbnet" language=","]

VBA code

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

Hello Mr. Oscar,

I modified your formula according to my need. I have ~800 row so it takes too much to calculate. Is there a way to speed it up ?