Forum Discussion
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 work if I have a =11.9-11.8 formula. It DOES work however on =0.05+0.05 or = 2.9-2.8. I tried formatting the cells every possible way - general, number, indentation, etc and no go. Attaching some screenshots. Could you help me out?
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:
3 Replies
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!
You are a genius - that was exactly the issue. Your solution immediately fixed all problematic instances in my entire document. Thank you very much!
