by Oz du Soleil | Oct 28, 2014 | Data Management, Excel Geekdom
THE PINOCCHIO THEORY In 1977 Bootsy Collins released the hit song Pinocchio Theory. Its main warning is: If you fake the funk, your nose will grow There are a lot of long noses in the data world–specifically with folks who continually bash Excel and write its...
by Oz du Soleil | Feb 23, 2012 | Data Integrity, Spreadsheet Development, Spreadsheet Tidiness, Tips
Let’s say you have 600 rows of data and you’re looking at a final number from column W telling you that you are owed a total of $17,384. Can you trust it? Suggestion: Create a formula that looks for any cells in column W that show the error: #NA....