Forum Discussion
Remove Error not working
I'm extracting data from excel where there are #REF errors in the spreadsheet. For some reason remove errors will not remove them. So far I have tried: Remove errors function from remove rows D...
Please did you ever find a solution to this? I'm absolutley stumped in a similar situation, years later. The only thing I seem able to do is to fix the #REF! error in my source Excel file. This is a wierd scenario where it's essentially a step-level error, but it should be a cell-level error. Because of this, replace / remove errors is not working as that only picks up cell-level errors.