I have a huge sheet with many formulas. Some value cells have bad data in them and need to be changed. All formulas associated with those cells appear as “#VALUE!”. It would take ages to find all such cells manually. Entering “#VALUE!” in “Find” doesn’t work. What do I do?
Thanks.