Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro question
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Question | Excel Discussion (Misc queries) | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
Macro Question | Excel Worksheet Functions | |||
Question about macro | Excel Discussion (Misc queries) | |||
question about the macro vb some one help? | Excel Programming |