Display duplicate entries in excel

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?