Find the first and last occurance of a report printed.

[dids72]

Hello,

I have a wookbook that contains about 180,000 rows of data across 3
spreadsheets. The data is in Column A and Column B. In Column A I
have Mainframe Report Number's and in Column B I have the dates the
reports have printed. Column A repeats the report number for each date
the report has printed as shown below.

COLUMN A COLUMN B
AA000001 6/23/06
AA000001 5/10/06
AA000001 10/02/05
AA000002 6/5/06
AA000002 5/10/06
AA000002 4/09/05
AA000002 3/12/04
AA000002 2/14/03


Is it possible to have a macro go through the spreadsheets and find the
first and last time each report was printed. So the data from above
would look like the below.


COLUMN A COLUMN B
AA000001 6/23/06
AA000001 10/02/05
AA000002 6/5/06
AA000002 2/14/03


Any help would be greatly appreciated.


Thanks,

DIDS

 

[Don Guillett]

Not necessary, or desirable to post,post, post. Be patient.
See answer in first post

 

[dids72]

Not necessary, or desirable to post,post, post. Be patient.
See answer in first post

Sorry about the multiple posts. Everytime I clicked the submit button
it went to "Could not find server page", but it looks like smehow they
posts that I thought failed made it.