Hi - Dave here.
Happy Friday!
In my last email, I shared a formula to
count errors on all worksheets in a workbook.
One of our newsletter readers then kindly pointed out that you can use Excel's Find and Replace feature to
list all errors in a workbook.
This is a great tip!
You can see the result in the screen below:
[
Read the complete article here]
Notice the list of errors includes multiple sheets. The asterisk (*) is a wildcard in Excel that will match any number of characters, so the idea here is to find values that start with a hash (#) and end with an exclamation point (!). The article above provides more detail and includes a description of the 10 formula errors you may encounter in Excel.
Excel formulas
We maintain a list of over 500 working formulas
here.
If you need more structure, we also offer
video training.
Have a great weekend!
Dave
