Return the nth largest date

[Graemea]

Hi,


I have raw data arranged as follows:


Column A: Product Codes
Column B: Month End Dates


There are dozens of different product codes in column A and each is associated with up to 10 month-end dates.


Can someone please suggest a formula that will put in cell C1 the earliest date in column B associated with a particular product code, in cell C2 the second earliest date, in cell C3 the third earliest date etc?


Thanks!

 

[AlanY]

can you work on this?

Book1
	A	B	C	D	E
1	Product Codes	Month End Dates		Product Codes	Month End Dates
2	P1	07/06/2019		P2	01/05/2019
3	P1	10/07/2019			14/05/2019
4	P1	03/04/2019			22/05/2019
5	P1	27/03/2019			25/05/2019
6	P1	14/04/2019			28/05/2019
7	P1	14/06/2019			31/05/2019
8	P1	20/05/2019			13/06/2019
9	P1	28/05/2019
10	P1	01/07/2019
11	P2	31/05/2019
12	P2	28/05/2019
13	P2	01/05/2019
14	P2	25/05/2019
15	P2	13/06/2019
16	P2	05/07/2019
17	P2	22/05/2019
18	P2	14/05/2019
19	P2	21/06/2019
Sheet4

Cell Formulas
Range	Formula
E2	{=SMALL(IF($A$2:$A$19=$D$2,$B$2:$B$19),ROW(D2)-ROW($D$1))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Graemea]

Thanks very much!!!

 

[Fluff]

How about

Excel 2013/2016
	A	B	C
1	abc1	31/01/2019	31/01/2019
2	abc2	28/02/2019	28/06/2019
3	abc3	28/03/2019	28/11/2019
4	abc4	28/04/2019
5	abc5	28/05/2019
6	abc1	28/06/2019
7	abc2	28/07/2019
8	abc3	28/08/2019
9	abc4	28/09/2019
10	abc5	28/10/2019
11	abc1	28/11/2019
12	abc2	28/12/2019
13	abc3	28/01/2020
14	abc4	28/02/2020
15	abc5	28/03/2020
All

Cell Formulas
Range	Formula
C1	{=IFERROR(SMALL(IF($A$1:$A$15="abc1",$B$1:$B$15),ROWS($1:1)),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[AlanY]

you're welcome

 

[Fluff]

I was obviously way too slow