Hi!

I am trying to find earliest and latest contract expiry dates for a
large number of companies, each with many contracts!

Right now my data is in the format:

Company ID / Contract Expiry (with the data in separate columns, of
course)

There can be up to 10 contracts per company.
E.g.
Company X / 3 January 2009
Company X / 5 December 2011
Company X / 10 November 2012

I need to find the earliest and latest expiry dates, so the output
would look like
Company X / 3 January 2009 / 10 November 2012

I really want some kind of MAXIF formula! Is there an easy way to do
this, or will I have to crack out the VBA?

Thank you for your help! : )