## Easily identify groups of duplicate rows

*Article updated on January 20, 2012*

**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**

Extract a list of duplicates from three columns combined using array formula in excel

Question: I have three ranges or lists and I need to extract duplicates from those ranges combined using excel array […]Filter unique distinct and duplicate values from a large data set in excel 2007

In this post I am going to describe how to filter duplicate and unique distinct values from a really large […]### One Response to “Easily identify groups of duplicate rows”

### Leave a Reply

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

<code>your formula</code>

Remember to convert less than and larger than signs to html character entities before you post your comment.

**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 ?