Results 1 to 2 of 2
  1. #1
    3 Star Lounger Omega3's Avatar
    Join Date
    Jan 2004
    Location
    Los Angeles, California, USA
    Posts
    341
    Thanks
    2
    Thanked 1 Time in 1 Post

    Autofilter Count Problem (2002)

    I have a file that has a single column (deleted the sensitive data). It contains a number 0, 2, or 3. If I apply autofilter to it and select 0 the status bar shows 3151 out of 3440. If I select 2 I get 18. If I select 3 I get 271. When I add those 3 numbers up I get 3440. The drop down autofilter box does not show an option for Blanks or NonBlanks so there are not blank rows.

    The problem is there are 3441 records in the file not 3440. I can not tell what the value is for the missing row! Did I miss something or is this a bug? Can you confirm this for me? The file is attached.

    Thanks much.
    You know it's time to diet when you push away from the table and the table moves.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Autofilter Count Problem (2002)

    As far as I can tell you have posted the same question twice. I have locked this thread. All replies to <post#=455821>post 455821</post#> please.

Posting Permissions

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