Hi,
I have a workbook which contains the database of sales Invoices almost about
60000 Invoices
Now in another worksheet I want to list out row details of the duplicate
Invoices or the details of the Invoices which is more than single invoice
no.
The data is something like below given table.
In sheet1:
doc_type doc_no doc_date
46 74000001 01/04/2006
46 74000002 01/04/2006
46 74000003 01/04/2006
46 74000004 01/04/2006
46 74000005 01/04/2006
46 74000006 01/04/2006
46 74000007 01/04/2006
46 74000007 01/04/2006
46 74000009 01/04/2006
46 74000010 01/04/2006
46 74000011 01/04/2006
46 74000011 02/04/2006
46 74000013 02/04/2006
46 74000014 02/04/2006
The answer in sheet2 would be
doc_type doc_no doc_date
46 74000007 01/04/2006
46 74000007 01/04/2006
46 74000011 01/04/2006
46 74000011 02/04/2006
i.e. the list of the duplicate doc_no. & its respective row details
Is it possible

--
Vicky