View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Manos Manos is offline
external usenet poster
 
Posts: 50
Default A list which don not include zero

Dear all

I have in column A accounts. In column C i have the values. Let's say that
all values should be zero.
The lines are more than 15.000.

I need to search all values in column C and find out if there is a value
different from zero.
I do not want ot use filters. I need a function in order to bring in a cell
the status OK all values are zero. (as check box for the user).
Any clever way to do it.