View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sherry Sherry is offline
external usenet poster
 
Posts: 116
Default Count with Auto-Filter On

How do I count the number (rows) of cells visible on my screen when auto
filter is on and enabled and I am using it to count rows of data. For
instance, in one column, if I have the words red, orange, green, etc., typed
500 times and I use auto filter to only expose the word red, how do I find
out how many rows of "red" I have. Thanks soooo much!
--
sherry