Forum Discussion

Hogstad_Raadgivning's avatar
Hogstad_Raadgivning
Iron Contributor
Nov 23, 2022
Solved

Filter using dynamic array as test citeria.

Hi,   The goal here is to find the lowest date in a list, using a unique list for match:   Tested with =MIN(FILTER($D$3:$D$32;$C$3:$C$32=G3#;"")) which gives an error.    =MIN(FILTER($D$3:$D$32...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Nov 23, 2022

    Hogstad_Raadgivning 

    =BYROW(G3#,LAMBDA(row,MIN(FILTER(D3:D32,C3:C32=row))))

    This formula refers to G3# and spills the results in my sheet.

     

Patrick2788's avatar
Patrick2788
Silver Contributor
Nov 23, 2022

Hogstad_Raadgivning 

VLOOKUP with the date sorted in ascending order:

=LET(data,SORT(C3:D32,2,1),VLOOKUP(G3#,data,2,0))

Resources