Find the first and last occurance of a report printed.

  • Thread starter Thread starter dids72
  • Start date Start date
D

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
 
Not necessary, or desirable to post,post, post. Be patient.
See answer in first post
 
Don said:
Not necessary, or desirable to post,post, post. Be patient.
See answer in first post
Click to expand...

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.
 
Back
Top