--
Patrick Molloy
Microsoft Excel MVP
---------------------------------
I Feel Great!
---------------------------------
"G-MAN" wrote in message
om...
I need help with first figuring out whether or not this is possible
and second writing the macro. I have a very large report, 13000
records. There are six columns: account #, name, birthdate, date of
visit, diagnosis, and location. There are many duplicate records.
For example, there may be ten records for Jane Doe. One record has a
date of visit of 10/12/2004 and nine records have a date of visit of
10/13/2004. I need to delete 8 of the nine records with the date of
10/13/2004. I then need to count the number of records with the same
account #. Is this possible?


Thanks in advance for all of your help!!!!

KrisG.