Chapter 33. Validating Data
Iâm entering scores of professional basketball games into Excel. I know that a team scores between 50 and 200 points a game. I once entered 1000 points instead of 100 points, which messed up my analysis. Is there a way to have Excel prevent me from making this type of error?
Iâm entering the date and amount of my business expenses for a new year. Early in the year, I often enter the previous year in the date by mistake. Is there a way I can set up Excel to prevent me from making this type of error?
Iâm entering a long list of numbers. Can I have Excel warn me if I enter a nonnumeric value?
My assistant needs to enter state abbreviations as she enters dozens and dozens of sales transactions. Can we set up a list ...
Get Microsoft® Excel Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
