Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Counting the results from an Excel autofilter 1
- Thread starter milnes
- Start date
-
1
- #2
Milnes,
You can use your status bar to display the count of the number of records in your autofilter. First make sure it's displayed. If not, go the the View menu and click status bar. If it is displayed, look at the right end of the bar where the word "NUM" usually is displayed. Right click at word and select Count. Count will display the number of records in the autofilter on your status bar. Not sure if this is what you were looking for, but hope it helps. [sig][/sig]
You can use your status bar to display the count of the number of records in your autofilter. First make sure it's displayed. If not, go the the View menu and click status bar. If it is displayed, look at the right end of the bar where the word "NUM" usually is displayed. Right click at word and select Count. Count will display the number of records in the autofilter on your status bar. Not sure if this is what you were looking for, but hope it helps. [sig][/sig]
LarryDeLaruelle
Technical User
Aug4570:
I tried your suggestion but the NUM continues to be displayed not the actual number of rows returned by the autofilter.
Do I need to set some other option to make this work? [sig]<p>Larry De Laruelle<br><a href=mailto:larry1de@yahoo.com>larry1de@yahoo.com</a><br><a href= > </a><br> [/sig]
I tried your suggestion but the NUM continues to be displayed not the actual number of rows returned by the autofilter.
Do I need to set some other option to make this work? [sig]<p>Larry De Laruelle<br><a href=mailto:larry1de@yahoo.com>larry1de@yahoo.com</a><br><a href= > </a><br> [/sig]
PaulMilnes
Technical User
Many thanks, AUG4570. That works a treat on my machine. However the colleague who asked me about it can't make it work, so I wonder if LarryDeLaruelle is right about some other option being required?.
Incidentally, Larry - look over on the left-hand side of the status bar. You may have missed it. (Sorry if this is obvious!)
Paul Milnes [sig][/sig]
Incidentally, Larry - look over on the left-hand side of the status bar. You may have missed it. (Sorry if this is obvious!)
Paul Milnes [sig][/sig]
LarryDeLaruelle
Technical User
Thanks Paul:
Sometimes the obvious is easily overlooked and I would have felt pretty much the fool if you had been correct.
Not this time, however. All I see on the left side of the Status Bar is "Ready" and "Num" on the right.
I checked all the settings in Tools/Options and could not find anything that looked like a toggle to turn the display on or off.
This has me intrigued now. Does anyone have an idea on what setting has to be enabled to make the autofilter display a count is the status bar? [sig]<p>Larry De Laruelle<br><a href=mailto:larry1de@yahoo.com>larry1de@yahoo.com</a><br><a href= > </a><br> [/sig]
Sometimes the obvious is easily overlooked and I would have felt pretty much the fool if you had been correct.
Not this time, however. All I see on the left side of the Status Bar is "Ready" and "Num" on the right.
I checked all the settings in Tools/Options and could not find anything that looked like a toggle to turn the display on or off.
This has me intrigued now. Does anyone have an idea on what setting has to be enabled to make the autofilter display a count is the status bar? [sig]<p>Larry De Laruelle<br><a href=mailto:larry1de@yahoo.com>larry1de@yahoo.com</a><br><a href= > </a><br> [/sig]
LarryDeLaruelle
Technical User
Ok, let me throw another twist into this mix.
I contacted a friend who teaches an Excel class at a local University. He sent me a sample workbook that he uses in class as an Autofilter example. When I opened it and set the Autofilter it displayed the results as expected in the status bar: "xx of yy records found". However, my workbook with Autofilter applied still does not show this on the status bar.
Unfortunately, when I called him for an explanation of this odd behaviour he did not have an answer. So much for modern education. (Actually, he's an excellent instructor and I think I've piqued his interest enough that he'll continue to look for an answer.)
Given this, it seems that the issue may be a setting specific to the workbook rather than for Excel in general. I'm just stumped on what it might be and where to find it and the Excel Help does not.
Whoever figures this out should write a FAQ for the board. Who knows, it might be worth a dinner. [sig]<p>Larry De Laruelle<br><a href=mailto:larry1de@yahoo.com>larry1de@yahoo.com</a><br><a href= > </a><br> [/sig]
I contacted a friend who teaches an Excel class at a local University. He sent me a sample workbook that he uses in class as an Autofilter example. When I opened it and set the Autofilter it displayed the results as expected in the status bar: "xx of yy records found". However, my workbook with Autofilter applied still does not show this on the status bar.
Unfortunately, when I called him for an explanation of this odd behaviour he did not have an answer. So much for modern education. (Actually, he's an excellent instructor and I think I've piqued his interest enough that he'll continue to look for an answer.)
Given this, it seems that the issue may be a setting specific to the workbook rather than for Excel in general. I'm just stumped on what it might be and where to find it and the Excel Help does not.
Whoever figures this out should write a FAQ for the board. Who knows, it might be worth a dinner. [sig]<p>Larry De Laruelle<br><a href=mailto:larry1de@yahoo.com>larry1de@yahoo.com</a><br><a href= > </a><br> [/sig]
Hey there,
I believe you're right Larry when stating that it may be the workbook settings instead of Excel. I opened another Excel worksheet that I'd gotten elsewhere and could not get my status bar to activate on this particular worksheet. I could not figure out why this was happening. I have no problems with any of my other worksheets. Okay, I'm stumped. BTW, the status bar (when you can get it to work)works for any selected group of cells, not only for autofilters. [sig][/sig]
I believe you're right Larry when stating that it may be the workbook settings instead of Excel. I opened another Excel worksheet that I'd gotten elsewhere and could not get my status bar to activate on this particular worksheet. I could not figure out why this was happening. I have no problems with any of my other worksheets. Okay, I'm stumped. BTW, the status bar (when you can get it to work)works for any selected group of cells, not only for autofilters. [sig][/sig]
- Thread starter
- #8
Found it! It appears to be a bit of a bug (shurely- 'undocumented feature' - Ed) in Excel. Here is the Knowledge base article URL:
I haven't been able to reproduce the error myself, possibly because my worksheet doesn't fall foul of any of the problems outlined in the KB article.
Paul [sig][/sig]
I haven't been able to reproduce the error myself, possibly because my worksheet doesn't fall foul of any of the problems outlined in the KB article.
Paul [sig][/sig]
LarryDeLaruelle
Technical User
Paul:
That did the trick.
Thanks for the tip. [sig]<p>Larry De Laruelle<br><a href=mailto:larry1de@yahoo.com>larry1de@yahoo.com</a><br><a href= > </a><br> [/sig]
That did the trick.
Thanks for the tip. [sig]<p>Larry De Laruelle<br><a href=mailto:larry1de@yahoo.com>larry1de@yahoo.com</a><br><a href= > </a><br> [/sig]
- Status
Similar threads
- Locked
- Question
- Question