Return 2 most recent from range.

[RLJ]

I need a formula that will take the most recent and second most recent dates and return the description for that date. I have a simple example of what I need and in F2 I want the Most recent date description and in F3 I want the second most recent date description.

Book1
	A	B	C	D	E	F
1	Date	Column 1	Column 1	Description		Return
2	12/12/2023			Test 1		Test 4
3	12/22/2023			Test 2		Test 3
4	1/5/2024			Test 3
5	1/15/2024			Test 4
Sheet1

Thank you for your help.

 

[dreid1011]

Maybe this:

Book1
	A	B	C	D	E	F
1	Date	Column 1	Column 1	Description		Return
2	12/12/2023			Test 1		Test 4
3	12/22/2023			Test 2		Test 3
4	1/5/2024			Test 3
5	1/15/2024			Test 4
Sheet4

Cell Formulas
Range	Formula
F2:F3	F2	=TAKE(CHOOSEROWS(SORT(A2:D5,1,-1),1,2),,-1)
Dynamic array formulas.

 

[RLJ]

Maybe this:

Book1
	A	B	C	D	E	F
1	Date	Column 1	Column 1	Description		Return
2	12/12/2023			Test 1		Test 4
3	12/22/2023			Test 2		Test 3
4	1/5/2024			Test 3
5	1/15/2024			Test 4
Sheet4

Cell Formulas
Range	Formula
F2:F3	F2	=TAKE(CHOOSEROWS(SORT(A2:D5,1,-1),1,2),,-1)
Dynamic array formulas.

I don't think this will work since on my dashboard sheet where these descriptions will be displayed are in merged cells and I get the #SPILL! when merging the cells. I think I need 2 separate formulas to make this work for my needs.

 

[dreid1011]

I don't think this will work since on my dashboard sheet where these descriptions will be displayed are in merged cells and I get the #SPILL! when merging the cells. I think I need 2 separate formulas to make this work for my needs.

Which cells are merged? I suppose that doesn't really matter.. here are the formulas split up:

Book1
	F
1	Return
2	Test 4
3	Test 3
Sheet4

Cell Formulas
Range	Formula
F2	F2	=TAKE(CHOOSEROWS(SORT(A2:D5,1,-1),1),,-1)
F3	F3	=TAKE(CHOOSEROWS(SORT(A2:D5,1,-1),2),,-1)

 

[RLJ]

Which cells are merged? I suppose that doesn't really matter.. here are the formulas split up:

Book1
	F
1	Return
2	Test 4
3	Test 3
Sheet4

Cell Formulas
Range	Formula
F2	F2	=TAKE(CHOOSEROWS(SORT(A2:D5,1,-1),1),,-1)
F3	F3	=TAKE(CHOOSEROWS(SORT(A2:D5,1,-1),2),,-1)

Spectacular. Thank you. I can't express my gratitude everyone that helps me out enough. I appreciate it so much.

 

[dreid1011]

Spectacular. Thank you. I can't express my gratitude everyone that helps me out enough. I appreciate it so much.

You're welcome, and happy to help.