Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: filter problem ! automatically showing record count on autof

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Ducati

    Have you tried "View>Status bar"



  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    the stausbar is on

  4. #4
    Board Regular sen_edp's Avatar
    Join Date
    Mar 2002
    Location
    Hellas
    Posts
    555
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi ducati

    please be more concise. what exactly is your
    problem?


  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

    Juan Pablo González
    http://www.juanpg.com

  8. #8
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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



  9. #9
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.



  10. #10
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!!!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •