How To Populate Last "N" Entries Conditionally?

[xlmaniac]

Dear All,
I do have a sample data-set across A1:C11 as follows.

SKU	Location	Posting Date
1	A	12-Jan
		14-Jan
		18-Jan
		19-Jan
		20-Jan
		23-Jan
2	D	13-Dec
		19-Dec
		28-Dec
		04-Jan

<tbody>
</tbody>

I would like to populate the last 3 posting date from the data set.
The desired result across F1:J3.

SKU	Region	Last Posting Date	2nd Last Posting Date	3rd Last Posting Date
1	A	23-Jan	20-Jan	19-Jan
2	D	04-Jan	28-Dec	19-Dec

<tbody>
</tbody>

Pls help in the formulae which can yield the desired result

Regards
Xlmainac

 

[DRSteele]

You should first alter the data so that each record is complete, otherwise this is too difficult. It's also wise to have the dates display fully.

Copy row3 down as necessary for each SKU and Location.

	A	B	C	D	E	F	G	H	I	J
1	SKU	Location	Posting Date			SKU	Region	Last Posting Date	2nd Last Posting Date	3rd Last Posting Date
2	1	A	1/12/18			1	A	1/23/18	1/20/18	1/19/18
3	1	A	1/14/18			2	D	1/04/18	12/28/17	12/19/17
4	1	A	1/18/18
5	1	A	1/19/18
6	1	A	1/20/18
7	1	A	1/23/18
8	2	D	12/13/17
9	2	D	12/19/17
10	2	D	12/28/17
11	2	D	1/04/18

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet3​

Array Formulas Cell Formula H2 {=LARGE(IF(($F2=$A$2:$A$11)*($G2=$B$2:$B$11),$C$2:$C$11,""),1)} I2 {=LARGE(IF(($F2=$A$2:$A$11)*($G2=$B$2:$B$11),$C$2:$C$11,""),2)} J2 {=LARGE(IF(($F2=$A$2:$A$11)*($G2=$B$2:$B$11),$C$2:$C$11,""),3)} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try to enter the {} manually yourself

<tbody>
</tbody>

 

[xlmaniac]

Thanks a lot for your help.
Really appreciate the same.
Regards
Xlmaniac

 

[DRSteele]

You're welcome. I'm glad to have helped.

 

[xlmaniac]

Dear DRSteele,
I am getting the following error with the folrmula.
COuld you pls check once?

SKU	Region	Last Posting Date	2nd Last Posting Date	3rd Last Posting Date
1	A	01-12-2018	#NUM!	#NUM!
2	D	01-04-2018	#NUM!	#NUM! Regards Xlmaniac

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>