How do I show the results of filter?
 

I'm using Excel 2000. I have a worksheet that gives me the right filtered
records. The problem that I'm having is that I do not see the number of
records that meet the filtered condition. I thought this feature can be
turned on by by right-clicking over the Filter Mode text on the bar at the
bottom of Excel. That hasn't work. So, how do I get the results of a filter
to show?
--
Bob

Hi Bob

See Debra's page about this
http://www.contextures.com/xlautofilter02.html#Count

--
Regards Ron de Bruin
http://www.rondebruin.nl


.(donotspam)" m wrote in message
...
I'm using Excel 2000. I have a worksheet that gives me the right filtered
records. The problem that I'm having is that I do not see the number of
records that meet the filtered condition. I thought this feature can be
turned on by by right-clicking over the Filter Mode text on the bar at the
bottom of Excel. That hasn't work. So, how do I get the results of a filter
to show?
--
Bob