•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
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#data cleaning solutions
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#natural language processing for spreadsheets
#Excel compatibility
#rows.com
#Excel alternatives
#AI formula generation techniques
#formula generator
#ERROR
#data cleaning