Classify real errors without misreading text
Your goal: Return a category and classic error code for each imported value while preserving source order.
Full task requirements
Enter one formula in G5. For all twelve values in B2:B13, return a twelve-row, two-column report. The first column is Missing for genuine #N/A, Error for the other six classic Excel errors, and Value for every other value. The second column is the documented error code 1 through 7 for a genuine error and numeric zero otherwise. Keep literal error-looking text, Boolean values and blanks in the Value category. Do not add headings.
| # | ||
|---|---|---|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 | ||
| 8 | ||
| 9 | ||
| 10 | ||
| 11 | ||
| 12 | ||
| 13 |
Find genuine missing-value errors
Rules for this step
Select genuine #N/A errors for Missing. Error-looking text stays an ordinary value.
Tap values in the worksheet to include or remove them. Type labels distinguish stored numbers, text, logical values, genuine blanks and genuine errors.
Your selected values will appear here.