Help with second oldest

[creative999]

Hi
I have a formula which shows the latest sale (below) but also need to show the second oldest. Any suggestions?

=IFERROR(INDEX(SORT(FILTER(SALES!A:M,(SALES!F:F=A1)),4,1),1,3),"--")

 

[Fluff]

Another option

=TAKE(SORT(FILTER(SALES!C:D,SALES!F:F=A1,""),2),2,1)

 

[shift-del]

Mappe8
	B
1	645
Tabelle1

Cell Formulas
Range	Formula
B1:C1	B1	=IFERROR(INDEX(SORT(FILTER(Sales!A1:M100,(Sales!F1:F100=A1)),4,1),{1,2},3),"--")
Dynamic array formulas.

 

[creative999]

Thank you.... worked perfectly.

 

[Fluff]

Glad we could help & thanks for the feedback.