Forum Discussion
Solved
Excel FILTER function not working with some formulas
Hey all, Very weird issue: The FILTER function doesn't return anything when the target cell contains certain (but not all) formulas. For example, it would work if I manually type 0.1 but it will NOT...
this could be a roundoff issue. try:
=FILTER(B3:D6, A3:A6=ROUND(A1,1), "no")
Excel has limited digits of resolution and 11.9-11.8 hits that:
this could be a roundoff issue. try:
=FILTER(B3:D6, A3:A6=ROUND(A1,1), "no")
Excel has limited digits of resolution and 11.9-11.8 hits that:
You are a genius - that was exactly the issue. Your solution immediately fixed all problematic instances in my entire document. Thank you very much!