View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
[email protected] nomail1983@hotmail.com is offline
external usenet poster
 
Posts: 58
Default How to find each cell with non-negative value?

On May 14, 6:41 pm, Gord Dibben <gorddibbATshawDOTca wrote:
From help on autofilter.
"When you use the AutoFilter command, AutoFilter arrows appear to the right of
the column labels in the filtered range."
Note "column labels" means titles in row 1
A bit ambiguous and does not specifically state that autofilter results will not
include the cell with the arrow.


Thanks for the confirmation. Makes sense now.