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.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
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.

 

Resources