Nov 23 2022 04:10 AM
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;$C$3:$C$32=G3;"") work, but the I have to copy the formual down several times, and I would like to avoid that.
Attached example file.
Best Regards
- Geir
Nov 23 2022 04:41 AM
Solution=BYROW(G3#,LAMBDA(row,MIN(FILTER(D3:D32,C3:C32=row))))
This formula refers to G3# and spills the results in my sheet.
Nov 23 2022 08:24 AM
As variant
=LET(
ph, LAMBDA(C3:C32),
dt, LAMBDA(D3:D32),
u, UNIQUE(ph()),
MINIFS(dt(), ph(), u)
)
Nov 23 2022 09:46 AM
VLOOKUP with the date sorted in ascending order:
=LET(data,SORT(C3:D32,2,1),VLOOKUP(G3#,data,2,0))
Nov 23 2022 04:41 AM
Solution=BYROW(G3#,LAMBDA(row,MIN(FILTER(D3:D32,C3:C32=row))))
This formula refers to G3# and spills the results in my sheet.