Quote:
Originally Posted by genevievebr0
Hmmm, not sure it would be possible. The table is already very wide.
|
The columns don't need to be wide if we make one for each code. Just wide enough to fit a single character.
Alternatively, we could make it one column and have an equation enter a code for each error encountered. Thus the cell error codes might look like "999L01 99P02 CNH CONV" or "1 3 6 12" or however you might like to code your errors.
Also, we could make an entirely new tab for the errors.
Quote:
|
Another idea. Number all the issues. For all conditional rules found in a row, have the number of the issue written at the end of the report. For example, rule 3, 7 and 12 apply. These numbers would be entered in column AM, AN and AO. What do you think?
|
Precisely how I described one solution above. Great minds think alike. Fortunately, so do we. ;-)