Hi there,
Can you help me with a formula?
I have a promotion, A. Promotion A ran on several dates. In seperate columns I would like to be able to retrieve the first and last date of the whole promotion (in this case, 1/1 and 3/15 respectively).


A B C
Promotion 1st Date Last Date
A 1/1/2007 1/15/2007
A 2/1/2007 2/28/2007
A 3/1/2007 3/15/2007
B 1/15/2007 1/28/2007
B 2/15/2007 2/20/2007

Thanks
Jill