Find the last occurrence, and return a value, and count number of occurances

[AndreaG]

Hi
I have attached below a sample of the data I am trying to analyse. Could anyone recommend a formula (or 3) which would return the date of the first occurrence of the text in column A, the last occurrence of the same, and the number of occurrences in total? They are sorted in the alpha numeric sequence. The ultimate aim is to find the length of time (months) between the first and last occurrence, and the number of occurrence for each contract number.

Many thanks in advance.

Kind regards
Andrea

[TABLE="width: 290"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD][TABLE="width: 144"]
<colgroup><col span="2"></colgroup><tbody>[TR]
[TD]Contract Number[/TD]
[TD]Date Raised[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]04/11/2010[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]04/11/2010[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]05/01/2011[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]01/03/2011[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]01/03/2011[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]15/03/2011[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]16/03/2011[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]10/06/2011[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]12/07/2011[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]21/07/2011[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]21/07/2011[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]17/02/2012[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]12/03/2012[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]21/09/2012[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]31/01/2011[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]21/07/2011[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]21/07/2011[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]14/10/2011[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]30/03/2012[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]30/11/2012[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]12/12/2012[/TD]
[/TR]
[TR]
[TD]AP0102[/TD]
[TD]06/12/2013[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]10/05/2011[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]01/08/2011[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]03/10/2011[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]04/10/2011[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]04/10/2011[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]03/11/2011[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]17/02/2012[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]24/05/2012[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]10/05/2011[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]14/10/2011[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]01/02/2012[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]25/11/2011[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]11/02/2011[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]14/07/2011[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]14/10/2011[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]23/02/2011[/TD]
[/TR]
[TR]
[TD]AP0103[/TD]
[TD]21/09/2011[/TD]
[/TR]
[TR]
[TD]AP0104[/TD]
[TD]09/06/2011[/TD]
[/TR]
[TR]
[TD]AP0104[/TD]
[TD]19/07/2011[/TD]
[/TR]
[TR]
[TD]AP0105[/TD]
[TD]14/10/2011[/TD]
[/TR]
[TR]
[TD]AP0105[/TD]
[TD]03/11/2011[/TD]
[/TR]
[TR]
[TD]AP0105[/TD]
[TD]17/11/2011[/TD]
[/TR]
[TR]
[TD]AP0105[/TD]
[TD]09/03/2011[/TD]
[/TR]
[TR]
[TD]AP0105[/TD]
[TD]01/09/2011[/TD]
[/TR]
[TR]
[TD]AP0105[/TD]
[TD]01/09/2011[/TD]
[/TR]
[TR]
[TD]AP0105[/TD]
[TD]01/09/2011[/TD]
[/TR]
[TR]
[TD]AP0105[/TD]
[TD]21/07/2011[/TD]
[/TR]
[TR]
[TD]AP0105[/TD]
[TD]30/03/2011[/TD]
[/TR]
[TR]
[TD]AP0105[/TD]
[TD]09/06/2011[/TD]
[/TR]
[TR]
[TD]AP0105[/TD]
[TD]06/07/2011[/TD]
[/TR]
[TR]
[TD]AP0105[/TD]
[TD]14/10/2011[/TD]
[/TR]
[TR]
[TD]AP0106[/TD]
[TD]12/04/2012[/TD]
[/TR]
[TR]
[TD]AP0107[/TD]
[TD]27/04/2012[/TD]
[/TR]
[TR]
[TD]AP0108[/TD]
[TD]24/05/2012[/TD]
[/TR]
[TR]
[TD]AP0108[/TD]
[TD]31/05/2012[/TD]
[/TR]
[TR]
[TD]AP0108[/TD]
[TD]05/10/2012[/TD]
[/TR]
[TR]
[TD]AP0108[/TD]
[TD]21/02/2013[/TD]
[/TR]
[TR]
[TD]AP0108[/TD]
[TD]30/09/2013[/TD]
[/TR]
[TR]
[TD]AP0108[/TD]
[TD]27/02/2014[/TD]
[/TR]
[TR]
[TD]AP0108[/TD]
[TD]04/11/2014[/TD]
[/TR]
[TR]
[TD]AP0110[/TD]
[TD]10/11/2014[/TD]
[/TR]
[TR]
[TD]AP0110[/TD]
[TD]27/11/2014[/TD]
[/TR]
[TR]
[TD]AP0110[/TD]
[TD]30/03/2015[/TD]
[/TR]
[TR]
[TD]AP0110[/TD]
[TD]08/04/2015[/TD]
[/TR]
[TR]
[TD]AP0110[/TD]
[TD]08/05/2015[/TD]
[/TR]
[TR]
[TD]AP0110[/TD]
[TD]26/04/2011[/TD]
[/TR]
[TR]
[TD]AP0111[/TD]
[TD]09/09/2011[/TD]
[/TR]
[TR]
[TD]AP0111[/TD]
[TD]12/05/2011[/TD]
[/TR]
[TR]
[TD]AP0111[/TD]
[TD]12/05/2011[/TD]
[/TR]
[TR]
[TD]AP0111[/TD]
[TD]15/07/2011[/TD]
[/TR]
[TR]
[TD]AP0111[/TD]
[TD]02/09/2011[/TD]
[/TR]
[TR]
[TD]AP0111[/TD]
[TD]02/09/2011[/TD]
[/TR]
[TR]
[TD]AP0111[/TD]
[TD]20/12/2016[/TD]
[/TR]
[TR]
[TD]AP0111[/TD]
[TD]10/02/2017[/TD]
[/TR]
[TR]
[TD]AP0112[/TD]
[TD]13/09/2017[/TD]
[/TR]
[TR]
[TD]AP0112[/TD]
[TD]15/12/2017[/TD]
[/TR]
[TR]
[TD]AP0112[/TD]
[TD]27/04/2011[/TD]
[/TR]
[TR]
[TD]AP0112[/TD]
[TD]14/10/2011[/TD]
[/TR]
[TR]
[TD]AP0113[/TD]
[TD]26/07/2012[/TD]
[/TR]
[TR]
[TD]AP0113[/TD]
[TD]11/12/2012[/TD]
[/TR]
[TR]
[TD]AP0113[/TD]
[TD]21/02/2013[/TD]
[/TR]
[TR]
[TD]AP0113[/TD]
[TD]05/06/2013[/TD]
[/TR]
[TR]
[TD]AP0113[/TD]
[TD]22/07/2014[/TD]
[/TR]
[TR]
[TD]AP0113[/TD]
[TD]26/07/2011[/TD]
[/TR]
[TR]
[TD]AP0114[/TD]
[TD]14/06/2011[/TD]
[/TR]
[TR]
[TD]AP0116[/TD]
[TD]14/07/2011[/TD]
[/TR]
[TR]
[TD]AP0116[/TD]
[TD]04/08/2011[/TD]
[/TR]
[TR]
[TD]AP0116[/TD]
[TD]16/09/2011[/TD]
[/TR]
[TR]
[TD]AP0116[/TD]
[TD]01/12/2011[/TD]
[/TR]
[TR]
[TD]AP0116[/TD]
[TD]09/12/2011[/TD]
[/TR]
[TR]
[TD]AP0117[/TD]
[TD]09/12/2011[/TD]
[/TR]
[TR]
[TD]AP0117[/TD]
[TD]17/02/2012[/TD]
[/TR]
[TR]
[TD]AP0117[/TD]
[TD]12/03/2012[/TD]
[/TR]
[TR]
[TD]AP0117[/TD]
[TD]31/05/2012[/TD]
[/TR]
[TR]
[TD]AP0118[/TD]
[TD]17/12/2012[/TD]
[/TR]
[TR]
[TD]AP0119[/TD]
[TD]17/12/2012[/TD]
[/TR]
[TR]
[TD]AP0120[/TD]
[TD]21/05/2013[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]21/05/2013[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]21/07/2011[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]11/08/2011[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]08/09/2011[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]30/09/2011[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]02/03/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]08/05/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]08/05/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]31/05/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]12/06/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]16/08/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]17/05/2013[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]01/08/2011[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]01/08/2011[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]05/04/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]13/04/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]24/05/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]16/08/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]30/11/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]18/01/2013[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]16/08/2013[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]20/08/2013[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]16/08/2011[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]01/09/2011[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]05/09/2011[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]01/09/2011[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]12/03/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]28/03/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]08/06/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]27/09/2012[/TD]
[/TR]
[TR]
[TD]AP0121[/TD]
[TD]05/10/2012[/TD]
[/TR]
[TR]
[TD]AP0122[/TD]
[TD]30/11/2012[/TD]
[/TR]
[TR]
[TD]AP0122[/TD]
[TD]21/02/2013[/TD]
[/TR]
[TR]
[TD]AP0123[/TD]
[TD]30/07/2013[/TD]
[/TR]
[TR]
[TD]AP0123[/TD]
[TD]30/07/2013[/TD]
[/TR]
[TR]
[TD]AP0123[/TD]
[TD]18/10/2013[/TD]
[/TR]
[TR]
[TD]AP0123[/TD]
[TD]18/10/2013[/TD]
[/TR]
[TR]
[TD]AP0123[/TD]
[TD]18/10/2013[/TD]
[/TR]
[TR]
[TD]AP0123[/TD]
[TD]03/10/2011[/TD]
[/TR]
[TR]
[TD]AP0123[/TD]
[TD]24/08/2011[/TD]
[/TR]
[TR]
[TD]AP0123[/TD]
[TD]28/10/2011[/TD]
[/TR]
[TR]
[TD]AP0123[/TD]
[TD]05/03/2012[/TD]
[/TR]
[TR]
[TD]AP0123[/TD]
[TD]12/03/2012[/TD]
[/TR]
[TR]
[TD]AP0123[/TD]
[TD]24/05/2012[/TD]
[/TR]
[TR]
[TD]AP0123[/TD]
[TD]02/07/2012[/TD]
[/TR]
[TR]
[TD]AP0123[/TD]
[TD]24/08/2012[/TD]
[/TR]
[TR]
[TD]AP0123[/TD]
[TD]28/09/2012[/TD]
[/TR]
[TR]
[TD]AP0124[/TD]
[TD]31/12/2012[/TD]
[/TR]
[TR]
[TD]AP0124[/TD]
[TD]06/09/2013[/TD]
[/TR]
[TR]
[TD]AP0124[/TD]
[TD]28/02/2014[/TD]
[/TR]
[TR]
[TD]AP0124[/TD]
[TD]06/03/2014[/TD]
[/TR]
[TR]
[TD]AP0124[/TD]
[TD]23/05/2017[/TD]
[/TR]
[TR]
[TD]AP0124[/TD]
[TD]23/09/2011[/TD]
[/TR]
[TR]
[TD]AP0124[/TD]
[TD]20/12/2011[/TD]
[/TR]
[TR]
[TD]AP0124[/TD]
[TD]17/01/2012[/TD]
[/TR]
[TR]
[TD]AP0124[/TD]
[TD]15/11/2011[/TD]
[/TR]
[TR]
[TD]AP0124[/TD]
[TD]22/11/2011[/TD]
[/TR]
[TR]
[TD]AP0124[/TD]
[TD]22/11/2011[/TD]
[/TR]
[TR]
[TD]AP0125[/TD]
[TD]20/09/2013[/TD]
[/TR]
[TR]
[TD]AP0125[/TD]
[TD]12/03/2014[/TD]
[/TR]
[TR]
[TD]AP0125[/TD]
[TD]28/08/2014[/TD]
[/TR]
[TR]
[TD]AP0125[/TD]
[TD]24/10/2014[/TD]
[/TR]
[TR]
[TD]AP0125[/TD]
[TD]29/10/2014[/TD]
[/TR]
[TR]
[TD]AP0126[/TD]
[TD]17/12/2014[/TD]
[/TR]
[TR]
[TD]AP0127[/TD]
[TD]05/01/2015[/TD]
[/TR]
[TR]
[TD]AP0128[/TD]
[TD]09/02/2015[/TD]
[/TR]
[TR]
[TD]AP0128[/TD]
[TD]20/02/2015[/TD]
[/TR]
[TR]
[TD]AP0128[/TD]
[TD]10/04/2015[/TD]
[/TR]
[TR]
[TD]AP0128[/TD]
[TD]05/06/2015[/TD]
[/TR]
[TR]
[TD]AP0129[/TD]
[TD]04/03/2016[/TD]
[/TR]
[TR]
[TD]AP0130[/TD]
[TD]21/10/2011[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]21/03/2012[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]17/11/2011[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]13/01/2012[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]05/04/2012[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]31/05/2012[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]16/08/2012[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]06/09/2012[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]28/09/2012[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]17/04/2013[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]16/10/2013[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]02/12/2013[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]19/12/2013[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]22/11/2011[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]24/08/2012[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]24/09/2012[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]20/12/2013[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]28/04/2014[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]05/11/2014[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]03/12/2014[/TD]
[/TR]
[TR]
[TD]AP0131[/TD]
[TD]26/01/2015[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]23/11/2011[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]24/11/2011[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]30/05/2012[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]24/10/2012[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]24/10/2012[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]01/12/2011[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]12/03/2012[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]01/12/2011[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]13/01/2012[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]01/02/2012[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]12/03/2012[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]30/05/2012[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]24/08/2012[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]28/09/2012[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]21/02/2013[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]08/03/2013[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]24/07/2013[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]24/07/2013[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]30/08/2013[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]28/04/2014[/TD]
[/TR]
[TR]
[TD]AP0132[/TD]
[TD]29/04/2014[/TD]
[/TR]
[TR]
[TD]AP0133[/TD]
[TD]15/03/2016[/TD]
[/TR]
[TR]
[TD]AP0134[/TD]
[TD]27/04/2016[/TD]
[/TR]
[TR]
[TD]AP0135[/TD]
[TD]27/04/2016[/TD]
[/TR]
[TR]
[TD]AP0136[/TD]
[TD]03/03/2017[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]03/03/2017[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]09/03/2017[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]03/08/2017[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]14/09/2017[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]14/09/2017[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]14/09/2017[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]08/12/2011[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]01/02/2012[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]02/03/2012[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]30/03/2012[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]05/04/2012[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]15/06/2012[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]16/08/2012[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]28/09/2012[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]28/11/2012[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]31/12/2012[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]28/03/2013[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]12/07/2013[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]29/10/2014[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]25/01/2013[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]16/12/2011[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]12/03/2012[/TD]
[/TR]
[TR]
[TD]AP0137[/TD]
[TD]24/05/2012[/TD]
[/TR]
[TR]
[TD]AP0138[/TD]
[TD]24/08/2012[/TD]
[/TR]
[TR]
[TD]AP0140[/TD]
[TD]28/09/2012[/TD]
[/TR]
[TR]
[TD]AP0141[/TD]
[TD]12/12/2012[/TD]
[/TR]
[TR]
[TD]AP0142[/TD]
[TD]20/02/2013[/TD]
[/TR]
[TR]
[TD]AP0143[/TD]
[TD]19/04/2013[/TD]
[/TR]
[TR]
[TD]AP0143[/TD]
[TD]29/07/2013[/TD]
[/TR]
[TR]
[TD]AP0144[/TD]
[TD]26/11/2013[/TD]
[/TR]
[TR]
[TD]AP0144[/TD]
[TD]20/12/2013[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]29/01/2014[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]25/03/2014[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]29/04/2014[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]29/04/2014[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]11/06/2014[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]20/12/2011[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]13/01/2012[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]17/02/2012[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]21/03/2012[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]21/12/2011[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]04/01/2012[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]27/02/2012[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]13/03/2012[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]25/09/2012[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]04/02/2013[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]17/03/2014[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]09/01/2012[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]02/02/2012[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]24/05/2012[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]30/05/2012[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]22/06/2012[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]22/10/2012[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]24/01/2013[/TD]
[/TR]
[TR]
[TD]AP0145[/TD]
[TD]11/02/2013[/TD]
[/TR]
[TR]
[TD]AP0146[/TD]
[TD]27/03/2013[/TD]
[/TR]
[TR]
[TD]AP0146[/TD]
[TD]30/04/2013[/TD]
[/TR]
[TR]
[TD]AP0146[/TD]
[TD]26/06/2013[/TD]
[/TR]
[TR]
[TD]AP0146[/TD]
[TD]29/07/2013[/TD]
[/TR]
[TR]
[TD]AP0147[/TD]
[TD]29/01/2014[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]24/03/2014[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]28/04/2014[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]28/08/2014[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]29/08/2014[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]17/10/2014[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]17/10/2014[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]18/01/2012[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]18/01/2012[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]12/03/2012[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]24/05/2012[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]24/05/2012[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]07/11/2012[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]11/12/2012[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]01/05/2013[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]25/10/2013[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]31/10/2013[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]26/11/2013[/TD]
[/TR]
[TR]
[TD]AP0148[/TD]
[TD]03/01/2014[/TD]
[/TR]
[TR]
[TD]AP0149[/TD]
[TD]09/09/2014[/TD]
[/TR]
[TR]
[TD]AP0149[/TD]
[TD]29/02/2012[/TD]
[/TR]
[TR]
[TD]AP0162[/TD]
[TD]13/09/2012[/TD]
[/TR]
[TR]
[TD]AP0162[/TD]
[TD]26/01/2012[/TD]
[/TR]
[TR]
[TD]AP0162[/TD]
[TD]30/03/2012[/TD]
[/TR]
[TR]
[TD]AP0162[/TD]
[TD]24/05/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]22/06/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]24/01/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]26/07/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]09/10/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]09/10/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]16/11/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]16/11/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]18/01/2013[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]08/02/2013[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]22/03/2013[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]08/01/2016[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]28/03/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]02/02/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]10/10/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]27/03/2013[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]29/02/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]23/03/2013[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]05/04/2013[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]13/03/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]16/04/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]05/10/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]15/10/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]27/03/2013[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]29/07/2013[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]19/03/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]07/11/2012[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]04/04/2014[/TD]
[/TR]
[TR]
[TD]AP0163[/TD]
[TD]14/09/2012[/TD]
[/TR]
[TR]
[TD]AP0164[/TD]
[TD]30/03/2012[/TD]
[/TR]
[TR]
[TD]AP0165[/TD]
[TD]03/04/2012[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]08/05/2012[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]08/05/2012[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]17/06/2012[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]14/05/2012[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]26/04/2012[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]15/06/2012[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]29/06/2012[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]25/07/2012[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]28/09/2012[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]21/02/2013[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]12/03/2015[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]26/07/2016[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]25/11/2016[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]28/11/2016[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]07/12/2016[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]16/01/2017[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]22/09/2017[/TD]
[/TR]
[TR]
[TD]AP0167[/TD]
[TD]30/05/2012[/TD]
[/TR]
[TR]
[TD]AP0168[/TD]
[TD]25/07/2012[/TD]
[/TR]
[TR]
[TD]AP0168[/TD]
[TD]02/05/2012[/TD]
[/TR]
[TR]
[TD]AP0168[/TD]
[TD]30/05/2012[/TD]
[/TR]
[TR]
[TD]AP0168[/TD]
[TD]10/05/2012[/TD]
[/TR]
[TR]
[TD]AP0168[/TD]
[TD]12/12/2012[/TD]
[/TR]
[TR]
[TD]AP0168[/TD]
[TD]29/07/2013[/TD]
[/TR]
[TR]
[TD]AP0168[/TD]
[TD]30/09/2013[/TD]
[/TR]
[TR]
[TD]AP0168[/TD]
[TD]28/04/2014[/TD]
[/TR]
[TR]
[TD]AP0168[/TD]
[TD]22/07/2014[/TD]
[/TR]
[TR]
[TD]AP0168[/TD]
[TD]30/11/2012[/TD]
[/TR]
[TR]
[TD]AP0168[/TD]
[TD]30/04/2013[/TD]
[/TR]
[TR]
[TD]AP0168[/TD]
[TD]10/10/2013[/TD]
[/TR]
[TR]
[TD]AP0168[/TD]
[TD]20/12/2013[/TD]
[/TR]
[TR]
[TD]AP0168[/TD]
[TD]17/01/2014[/TD]
[/TR]
[TR]
[TD]AP0169[/TD]
[TD]30/05/2014[/TD]
[/TR]
[TR]
[TD]AP0170[/TD]
[TD]11/06/2014[/TD]
[/TR]
[TR]
[TD]AP0170[/TD]
[TD]18/06/2014[/TD]
[/TR]
[TR]
[TD]AP0170[/TD]
[TD]18/06/2014[/TD]
[/TR]
[TR]
[TD]AP0170[/TD]
[TD]23/07/2014[/TD]
[/TR]
[TR]
[TD]AP0171[/TD]
[TD]22/08/2014[/TD]
[/TR]
[TR]
[TD]AP0171[/TD]
[TD]08/10/2014[/TD]
[/TR]
[TR]
[TD]AP0171[/TD]
[TD]08/10/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]04/11/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]05/11/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]13/11/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]27/11/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]10/12/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]23/02/2015[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]11/05/2012[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]27/07/2012[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]17/12/2012[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]29/07/2013[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]31/10/2013[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]27/02/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]16/09/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]15/10/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]05/11/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]22/04/2015[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]13/07/2015[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]15/06/2012[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]27/07/2012[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]16/08/2012[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]16/08/2012[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]10/09/2012[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]26/06/2013[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]29/07/2013[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]31/10/2013[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]26/11/2013[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]22/01/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]04/06/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]24/07/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]22/08/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]08/09/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]25/01/2017[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]15/10/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]20/10/2014[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]19/01/2015[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]06/10/2015[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]15/06/2012[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]27/07/2012[/TD]
[/TR]
[TR]
[TD]AP0172[/TD]
[TD]15/06/2012[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]18/03/2013[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]10/10/2013[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]31/10/2013[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]06/12/2013[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]22/06/2012[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]10/09/2012[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]16/10/2012[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]25/10/2012[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]23/01/2013[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]28/02/2013[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]08/03/2013[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]30/04/2013[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]17/05/2013[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]06/09/2013[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]26/09/2013[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]26/09/2013[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]06/12/2013[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]03/01/2014[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]28/02/2014[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]20/07/2012[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]20/07/2012[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]17/07/2012[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]26/07/2012[/TD]
[/TR]
[TR]
[TD]AP0173[/TD]
[TD]17/09/2012[/TD]
[/TR]
[TR]
[TD]AP0174[/TD]
[TD]26/10/2012[/TD]
[/TR]
[TR]
[TD]AP0175[/TD]
[TD]31/10/2012[/TD]
[/TR]
[TR]
[TD]AP0175[/TD]
[TD]31/10/2012[/TD]
[/TR]
[TR]
[TD]AP0175[/TD]
[TD]30/11/2012[/TD]
[/TR]
[TR]
[TD]AP0175[/TD]
[TD]07/12/2012[/TD]
[/TR]
[TR]
[TD]AP0176[/TD]
[TD]31/12/2012[/TD]
[/TR]
[TR]
[TD]AP0176[/TD]
[TD]31/01/2013[/TD]
[/TR]
[TR]
[TD]AP0176[/TD]
[TD]28/02/2013[/TD]
[/TR]
[TR]
[TD]AP0176[/TD]
[TD]28/06/2013[/TD]
[/TR]
[TR]
[TD]AP0176[/TD]
[TD]29/07/2013[/TD]
[/TR]
[TR]
[TD]AP0176[/TD]
[TD]17/12/2013[/TD]
[/TR]
[TR]
[TD]AP0176[/TD]
[TD]13/06/2014[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

How about 5 formulas?

	A	B	C	D	E	F	G	H
Contract Number	Date Raised	Contract	First Date	Last Date	Number of months between	Number of occurences
AP0102	AP0102
AP0102	AP0103
AP0102	AP0104
AP0102	AP0105
AP0102	AP0106
AP0102	AP0107
AP0102	AP0108
AP0102	AP0110
AP0102	AP0111
AP0102	AP0112

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]11/4/2010[/TD]
[TD="align: right"][/TD]

[TD="align: right"]11/4/2010[/TD]
[TD="align: right"]12/6/2013[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]22[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]11/4/2010[/TD]
[TD="align: right"][/TD]

[TD="align: right"]2/11/2011[/TD]
[TD="align: right"]5/24/2012[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]17[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]1/5/2011[/TD]
[TD="align: right"][/TD]

[TD="align: right"]6/9/2011[/TD]
[TD="align: right"]7/19/2011[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]3/1/2011[/TD]
[TD="align: right"][/TD]

[TD="align: right"]3/9/2011[/TD]
[TD="align: right"]11/17/2011[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]12[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]3/1/2011[/TD]
[TD="align: right"][/TD]

[TD="align: right"]4/12/2012[/TD]
[TD="align: right"]4/12/2012[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]3/15/2011[/TD]
[TD="align: right"][/TD]

[TD="align: right"]4/27/2012[/TD]
[TD="align: right"]4/27/2012[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]3/16/2011[/TD]
[TD="align: right"][/TD]

[TD="align: right"]5/24/2012[/TD]
[TD="align: right"]11/4/2014[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]7[/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]6/10/2011[/TD]
[TD="align: right"][/TD]

[TD="align: right"]4/26/2011[/TD]
[TD="align: right"]5/8/2015[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]6[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]7/12/2011[/TD]
[TD="align: right"][/TD]

[TD="align: right"]5/12/2011[/TD]
[TD="align: right"]2/10/2017[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]8[/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]7/21/2011[/TD]
[TD="align: right"][/TD]

[TD="align: right"]4/27/2011[/TD]
[TD="align: right"]12/15/2017[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]4[/TD]

</tbody>

Sheet4​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G2[/TH]
[TD="align: left"]=DATEDIF(E2,F2,"m")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H2[/TH]
[TD="align: left"]=COUNTIF(A:A,D2)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D2[/TH]
[TD="align: left"]{=IFERROR(INDEX($A:$A,SMALL(IF(MATCH($A$2:$A$445,$A$2:$A$445,0)=ROW($A$2:$A$445)-ROW($A$2)+1,ROW($A$2:$A$445)),ROWS($D$2:$D2))),"")}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E2[/TH]
[TD="align: left"]{=MIN(IF($A$2:$A$445=D2,$B$2:$B$445))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F2[/TH]
[TD="align: left"]{=MAX(IF($A$2:$A$445=D2,$B$2:$B$445))}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]

 

[AndreaG]

Perfect - many thanks

 

[Eric W]

Glad to help