Forum Discussion
Filter Function #DIV/0!
I am creating a dynamic list that returns values in a column based on another column. The data is being pulled from another worksheet with cell references to a pivot table (ex: =sheet2!A1); however, ...
Wallsda Difficult to visualise, but when you refer to a cell inside a pivot table like you say, that particular cell might change from a number to nothing when you apply a slicer. This cell would then become a zero and may lead to a #DIV/0 error, depending on how you use it in the formula.
Can you share a workbook or a screenshot showing "before" and "after"? That would help a lot.
Thank you for the interest in helping me solve this issue. I got it resolved. The pivot table causing the issue was showing calculations as a percent of row total like I wanted, but when I referenced that data on a different sheet, it was pulling the error with it which caused the filter function to only return div/0. I just used an errorif function to filter out the errors which fixed the issue.