Filter based on minimum value C for each value A

Question

I'm trying to find a way to filter by a value, and then filter and keep only the lowest value.

So the order would look like this:

It first filters the middle column by the input, but then I'm struggling to keep only the small right column value for each left column value. If it simplifies anything, my end goal is to sum the resulting right column together.

joswoolley · Accepted Answer

David-A-S&nbsp;&nbsp;Assuming your chosen input is in A1 and data in C1:E9&nbsp;=LET(
    ξ, A1,
    ζ, C1:E9,
    ε, LAMBDA(α, β, INDEX(α, , β)),
    γ, ε(ζ, 2),
    δ, FILTER(ζ, γ = ξ),
    κ, ε(δ, 1),
    λ, ε(δ, 3),
    FILTER(δ, λ = BYROW(κ, LAMBDA(μ, MIN(IF(κ = μ, λ)))))
)&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Filter based on minimum value C for each value A

Share

Resources