Hello,
Here is am example of data pulled from a query into excel. What I need to do
is create a many to one relationship after the data is pulled:
Date Num Incident Completion Date
12/16/2004 326 39413 1/13/2005
12/16/2004 326 38314 1/13/2005
12/16/2004 326 35602 1/13/2005

So all the incidents related to num 326 should display as a count of how
many there are (3), the date shuld just display 12/16/2004 and there should
only be one completion date 1/13/2005...ca this be done without creating
another sheet to massage the data? Can it be done when it is pulled?

Thanx