filter problem ! automatically showing record count on autof

ducati · Mar 23rd, 2002, 06:14 AM

I HAVE THE FOLLOWING PROBLEM:

When i do an autofilter on a column and I choose a value, it will normally show automatically how many records of that value are found. But on other computers it doesn't do this. How can I toggle on/off this feature. Is this different between versions of excel?

Dave Hawley · Mar 23rd, 2002, 07:31 AM

Hi Ducati

Have you tried "View>Status bar"

ducati · Mar 23rd, 2002, 07:38 AM

the stausbar is on

sen_edp · Mar 23rd, 2002, 08:15 AM

hi ducati

please be more concise. what exactly is your
problem?

Yogi Anand · Mar 23rd, 2002, 08:40 AM

Hi ducati:
The setting is set on specific computer. To see the COUNT of items filtered, this is what you do ...
1) As Dave Hawley and sen_edp suggested make sure that STATUBAR view is on.
2) Right click on the status bar and a context based menu will open up -- this will allow you to toggle between NONE, SUM, COUNT, AVERAGE, MAX, MIN, ...
3) Select the cells about which you want to see the chosen statistic on the STATUS BAR
4) Enjoy the view

HTH
Plese post if it works for you ... otherwise explain a little further and we will take it from there!

_________________
Yogi Anand
Edit: Deleted reference to inactive web site from signature line

[ This Message was edited by: Yogi Anand on 2003-01-19 18:40 ]

Juan Pablo González · Mar 23rd, 2002, 02:29 PM

I believe it was Mike W. who told me (us) that the AutoFilter "count" wouldn't work if the filtered range included formulas. That may be the thing that is happening.

Juan Pablo González · Mar 23rd, 2002, 02:30 PM

You could use a SUBTOTAL formula to count only visible cells.

Ivan F Moala · Mar 24th, 2002, 02:28 AM

I think what may have happened is that the
statusbar has been set by some other application.....

What you will need to do is return it back to Excel.....eg

Sub AutoFilter_DisplayOn()
Application.StatusBar = False
End Sub

To turn the AutoFilter statusdisplay off then

Sub AutoFilter_DisplayOff()
Application.StatusBar = ""
End Sub

OR place in any other Text to replace what is
currently displayed.....

Ivan

Dave Hawley · Mar 24th, 2002, 04:35 AM

Juan, I'm afraid you have been mislead, formuals will not effect this. I would be very dissapointed if such a feature was effected by this. After all Excel is a Spreadsheet program!

Ivan, I think you maybe onto something there.

ducati · Mar 24th, 2002, 06:15 AM

you are right, it has nothing to do with formulas. It has something to do with the statusbar, the view, but I still don't know what!!!!

Mar 23rd, 2002, 02:29 PM	#6
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	I believe it was Mike W. who told me (us) that the AutoFilter "count" wouldn't work if the filtered range included formulas. That may be the thing that is happening. __________________ Regards, Juan Pablo González http://www.juanpg.com

Mar 23rd, 2002, 02:30 PM	#7
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	You could use a SUBTOTAL formula to count only visible cells. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 23rd, 2002, 06:14 AM	#1
ducati New Member Join Date: Mar 2002 Posts: 3	I HAVE THE FOLLOWING PROBLEM: When i do an autofilter on a column and I choose a value, it will normally show automatically how many records of that value are found. But on other computers it doesn't do this. How can I toggle on/off this feature. Is this different between versions of excel?

Mar 23rd, 2002, 07:31 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Ducati Have you tried "View>Status bar"

Mar 23rd, 2002, 07:38 AM	#3
ducati New Member Join Date: Mar 2002 Posts: 3	the stausbar is on

Mar 23rd, 2002, 08:15 AM	#4
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	hi ducati please be more concise. what exactly is your problem?

Mar 23rd, 2002, 08:40 AM	#5
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi ducati: The setting is set on specific computer. To see the COUNT of items filtered, this is what you do ... 1) As Dave Hawley and sen_edp suggested make sure that STATUBAR view is on. 2) Right click on the status bar and a context based menu will open up -- this will allow you to toggle between NONE, SUM, COUNT, AVERAGE, MAX, MIN, ... 3) Select the cells about which you want to see the chosen statistic on the STATUS BAR 4) Enjoy the view HTH Plese post if it works for you ... otherwise explain a little further and we will take it from there! _________________ Yogi Anand Edit: Deleted reference to inactive web site from signature line [ This Message was edited by: Yogi Anand on 2003-01-19 18:40 ]

Mar 24th, 2002, 02:28 AM	#8
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	I think what may have happened is that the statusbar has been set by some other application..... What you will need to do is return it back to Excel.....eg Sub AutoFilter_DisplayOn() Application.StatusBar = False End Sub To turn the AutoFilter statusdisplay off then Sub AutoFilter_DisplayOff() Application.StatusBar = "" End Sub OR place in any other Text to replace what is currently displayed..... Ivan

Mar 24th, 2002, 04:35 AM	#9
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Juan, I'm afraid you have been mislead, formuals will not effect this. I would be very dissapointed if such a feature was effected by this. After all Excel is a Spreadsheet program! Ivan, I think you maybe onto something there.

Mar 24th, 2002, 06:15 AM	#10
ducati New Member Join Date: Mar 2002 Posts: 3	you are right, it has nothing to do with formulas. It has something to do with the statusbar, the view, but I still don't know what!!!!