Uploaded April 2014 | Updated September 2026, 1 hour ago

---

Excel's 'Circle Invalid Data' feature is great for cleaning up data. However, it doesn't tell you the total number and you have to scroll down the list to find all of them.
In this video I show you a way to count them and put them all together to make your clean up a little easier.