Display duplicate entries in excel

[tsr_83]

Hi,

I have data in 4 columns (Date, name, tag id & status). The data is updated in the sheet continuously. I want to have a macro that has to display the following details:

Tag id can be repeated on different dates but should not be repeated on a same day and if repeated, it denotes that it is a duplicate

When the macro is executed using a short cut key, it has to display with row# like below:

1. There are 3 duplicate entries for seq. no XXXXXXXX and they are:

Date Name Tag id Status Row No

15-Aug-10 Allister 18025366 D1 2
15-Aug-10 Allister 18025366 D1 156
15-Aug-10 Allister 18025366 D1 159

PFA the sample data. Can you please help me out on this?

[davesexcel]

Your post does not match your example
There is only 2 - 18025366

This appears in row 2 & 27

And they are not duplicate rows

[tsr_83]

Hi,

Sorry. Please find attached the updated file. It has duplicate entries.
To give clarity, duplicate is when two entries are listed on a same day even by different names.
Thanks in anticipation.

[tsr_83]

Hi Dave,

Did you get a chance to look through my updated file?

[davesexcel]

Give this a go,

Please Login or Register  to view this content.

[tsr_83]

Hi Dave,
Is it to be put under This workbook or in separate module?

[davesexcel]

Seperate module,
best to create a button and paste the code into there

[tsr_83]

Dave,

it just returns the row# in column E randomly. it has display items with no. of duplicate entries with a under a column heading "No. of duplicates"
For Ex: Tag id: 18019728 appears 4 times in the data - 1 + 3 duplicate.
Result can be shown in a new sheet so that user won't be confused and raw data remains the same.

Sorry to bother you. Thanks for your time

[davesexcel]

The code does what you have explained in your first post, maybe you want to try Auto Filter.
http://www.contextures.com/xlautofilter01.html