Forum Discussion
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...
=BYROW(G3#,LAMBDA(row,MIN(FILTER(D3:D32,C3:C32=row))))This formula refers to G3# and spills the results in my sheet.
As variant
=LET(
ph, LAMBDA(C3:C32),
dt, LAMBDA(D3:D32),
u, UNIQUE(ph()),
MINIFS(dt(), ph(), u)
)