I'm currently upgrading my sheets for an MTB program. I'm changing all my formulas to arrayformula so as to avoid anyone being left out when I forgot to drag the formula.

All that's left is the formula in cell J3.

Here's the link to the spreadsheet.

The formula is to count each plate numbers and if it matches with F2, return its latest time.

Any help is much appreciated.

CodePudding user response：

can you try:

=BYROW(C3:C,LAMBDA(cx,IF(cx="",,IF(COUNTIF(G:G,cx)=F2,IFNA(VLOOKUP(cx,SORT(G:H,2,),2,)),"DNF"))))