How To Track Down Excel Formula Errors (16 Examples)

Topics: Data Validation, Text Formulas, Date Formulas, Flash Fill and Array Formulas

 

 

Topics in this video:
1. List of possible errors in Excel (00:08 min)
2. 4 Steps to finding formula errors (00:30 min)
3. 3 Examples of how to use the 4 steps (01:44 min)
4. Cleaning Text data with the TRIM function and Paste Special Values (10:50 min)
5. Cleaning Date data (Dates stored as text) with the Text To Columns function (13:43 min)
6. Examples of #DIV/0! #REF! #NAME? #N/A #VALUE! #NULL! #NUM! ####### Circular Cell Reference Errors (16:39 min)

#DIV/0! error
#REF! error
#NAME? error
#N/A error
#VALUE! error
#NULL! error
#NUM! error

Questions