Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi All,
Don't know if this is a bug in Excel, or something I'm doing wrong? Usually when using autofilter the number of records is shown in the status bar (i.e. "2 of 500 records shown"), but on this particular sheet, it doesn't show up. It seems to work on some sheets and not others. Any ideas why? I'm running excel 2002 SP3 on WinXP SP1. Thanks in advance, Alex |
#2
![]() |
|||
|
|||
![]()
Debra Dalgleish's site explains it:
http://www.contextures.com/xlautofilter02.html#Count Alex Lush wrote: Hi All, Don't know if this is a bug in Excel, or something I'm doing wrong? Usually when using autofilter the number of records is shown in the status bar (i.e. "2 of 500 records shown"), but on this particular sheet, it doesn't show up. It seems to work on some sheets and not others. Any ideas why? I'm running excel 2002 SP3 on WinXP SP1. Thanks in advance, Alex -- Dave Peterson |
#3
![]() |
|||
|
|||
![]()
Thanks Dave, thats page was very helpful.
Looks like I'm stuck with it until I upgrade office!! Cheers, Alex "Alex Lush" wrote: Hi All, Don't know if this is a bug in Excel, or something I'm doing wrong? Usually when using autofilter the number of records is shown in the status bar (i.e. "2 of 500 records shown"), but on this particular sheet, it doesn't show up. It seems to work on some sheets and not others. Any ideas why? I'm running excel 2002 SP3 on WinXP SP1. Thanks in advance, Alex |
#4
![]() |
|||
|
|||
![]()
Even after you upgrade, you'll still be stuck. (It still applies through
xl2003, at least.) Alex Lush wrote: Thanks Dave, thats page was very helpful. Looks like I'm stuck with it until I upgrade office!! Cheers, Alex "Alex Lush" wrote: Hi All, Don't know if this is a bug in Excel, or something I'm doing wrong? Usually when using autofilter the number of records is shown in the status bar (i.e. "2 of 500 records shown"), but on this particular sheet, it doesn't show up. It seems to work on some sheets and not others. Any ideas why? I'm running excel 2002 SP3 on WinXP SP1. Thanks in advance, Alex -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multiple results when using filter function | Excel Worksheet Functions | |||
How do I show number of records that meet criteria filter | Excel Discussion (Misc queries) | |||
Auto Filter Multiple Selections | Excel Discussion (Misc queries) | |||
Auto Filter Limit Question | Excel Discussion (Misc queries) | |||
assign auto number and auto date | Excel Discussion (Misc queries) |