Search for date and penultimate date and numbers

[Wojciech]

Hi,
please help me write the formula. I am attaching a screenshot that shows the table and solution. The formula should be filled with the AAA or BBB (A13 and A14) and the formula should find the latest date (B13 and B14) and the number (number of kilometers) assigned to it (C13 and C14). The formula in D13,D14 finds the penultimate date and in E13 and E14 penultimate date number assigned to the dates.

 

[Wojciech]

So why does the function still work correctly after adding the third parameter CCC and the third searched row number 20? Please check the screenshot.

Edit: I think I understand now. These are the two lines we are looking for and they are calculated in "memory".

 

[Wojciech]

When there is one AAA row in the table or I ask for a CCC parameter that does not exist in the table, the function throws errors. Please help me improve the function.

km.xlsx
	A	B	C	D	E	F	G
1	Table:
2	Name	Date	KM
3	AAA	2023-09-07	30019
4	BBB	2023-07-27	24972
5	BBB	2023-08-04	25695
6	BBB	2023-07-07	23392
7
8
9		=INDEX(SORT(FILTER($B$2:$C$8,$A$2:$A$8=A13),1,-1),{1,1,2,2},{1,2,1,2})
10
11	When there is one AAA row in the table or I ask for a CCC parameter that does not exist in the table, the function throws errors.
12		Solution:
13	inquiry:	Last		Second to last
14	AAA	2023-09-07	30019	#ADR!	#ADR!
15	BBB	2023-08-04	25695	2023-07-27	24972
16	CCC	#OBL!	#OBL!	#OBL!	#OBL!
17
18	The expected result.
19		Solution:
20	inquiry:	Last		Second to last
21	AAA	2023-09-07	30019
22	BBB	2023-08-04	25695	2023-07-27	24972
23	CCC
24
km

Cell Formulas
Range	Formula
B21:E22,B14:E16	B14	=INDEX(SORT(FILTER($B$2:$C$6,$A$2:$A$6=A14),1,-1),{1,1,2,2},{1,2,1,2})
Dynamic array formulas.

 

[Fluff]

How about

=IFERROR(INDEX(SORT(FILTER($B$2:$C$6,$A$2:$A$6=A21),1,-1),{1,1,2,2},{1,2,1,2}),"")