Forum Discussion
Help with Filter Formula
Hello Microsoft Excel Community, I'm having trouble making a filter formula work. Perhaps someone can help me out. I'm trying to filter a list of job numbers if the quantity is +/- 5% from th...
CM1927 Something along these lines should do the trick:
=LET(
base, B2, pct, B3, jobs, A6:A25, qty, B6:B25,
lower, base*(1-pct),
upper, base*(1+pct),
FILTER(jobs, (qty>=lower)*(qty<=upper), "none")
)
Written without the LET function would look like this:
=FILTER(A6:A25, (B6:B25>=B2*(1-B3))*(B6:B25<=B2*(1+B3)), "none")
See attached...
