O
olivialott
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! : )
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! : )