Reporting Errors?
 

I have a spreadsheet where there are descriptions (Net Sales, Purchases,
Salaries, Bonus, etc.) in column A and the values are in column AT.

On another tab, I want to be able to show which amounts have 0 as well
as which have errors (div0, ref, etc.). I know I could just do
something like...
=IF(OR(ISERROR(AT7),AT7=0),A7,"Error")
for each line, but I rather have it just show the ones that people need
to check.

The best would be...

Purchases = 0
Bonus = Error

Not...
Net Sales =
Purchases = 0
Salaries =
Bonus = Error

Any ideas? Some kind of lookup that can display a list? A macro?

Thanks in advance,
Tom


--
tomandrobyn
------------------------------------------------------------------------
tomandrobyn's Profile: http://www.excelforum.com/member.php...o&userid=13879
View this thread: http://www.excelforum.com/showthread...hreadid=389105