•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Cleaning an excel file and encountered entries marked as error. What is the best course of action for these?
I was tasked with data cleaning on this file and noticed that a lot of entries were marked as ERROR. See example below (not actual data set, since I can't share) I wanted to know what would be the best course of action for these, since I'm not familiar with standard practices. Should I let them be or should I also mark them as unknown instead?
They're not actual errors by the way, like the formula was wrong or something and can't output it. It's just "ERROR" typed in there.
| Transaction ID | Product | Amount | Price | Total | Date |
|---|---|---|---|---|---|
| 190 | Apple | 1 | 1 | 1 | ERROR |
| 128 | Unknown | 2 | 2 | 4 | 12-12-12 |
| 127 | ERROR | 3 | 3 | 9 | UNKNOWN |
[link] [comments]
Want to read more?
Check out the full article on the original site