79214052

Date: 2024-11-22 07:47:56
Score: 1.5
Natty:
Report link

CHOOSEROWS with FILTER to find second to last match

Formula: =CHOOSEROWS(FILTER(A2:A24, B2:B24 = F4), (COUNTA(FILTER(A2:A24, B2:B24 = F4))-1))

This formula uses functions such as FILTER(to get values matching the name) and CHOOSEROWS to to get the desired outcome.

Sample Output enter image description here

References: CHOOSEROWS, FILTER

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: 4thAnd1