1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel Help

Discussion in 'Microsoft Office Specialist (MOS)' started by Nelix, Nov 4, 2003.

  1. Nelix
    Honorary Member

    Nelix Gigabyte Poster

    1,412
    3
    82
    Here's one for you Office Specialists.

    We have a finance spreadsheet that when we run a filter on it it does not show any cells that contain '3000' in the drop down filter menu it goes from 2999 to 3001 and we know that there is a 3000 entry in there.

    Any clues??????
     
    Certifications: A+, 70-210, 70-290, 70-291
    WIP: 70-294
  2. Phil
    Honorary Member

    Phil Gigabyte Poster

    1,680
    7
    87
    Derek , the only thing I can think of is that 3000 is the top row and it's treating it as a header instead of data.
     
    Certifications: MCSE:M & S MCSA:M CCNA CNA
    WIP: 2003 Upgrade, CCNA Upgrade
  3. Nelix
    Honorary Member

    Nelix Gigabyte Poster

    1,412
    3
    82
    thanks Phil, will go and have a look.

    Will let you know
     
    Certifications: A+, 70-210, 70-290, 70-291
    WIP: 70-294
  4. Phil
    Honorary Member

    Phil Gigabyte Poster

    1,680
    7
    87
    Derek,

    Did you find a solution to this? I've just come across a PC doing this at work and it isn't because the value is the top row. It is in a 29,000 row sheet, so don't know if this anything to do with it. A quick search with google didn't yield anything but I didn't search very hard.

    The bosses attitude is that our respnsibility ends when excel is installed and running, design errors in spreadsheets are a training issue. Trying to introduce the users to this concept is slightly entertaining :D
     
    Certifications: MCSE:M & S MCSA:M CCNA CNA
    WIP: 2003 Upgrade, CCNA Upgrade
  5. Nelix
    Honorary Member

    Nelix Gigabyte Poster

    1,412
    3
    82
    I know what you mean Si however I did not solve this issue, to be honest I did not have time to go back to the PC in question to investigate further.

    One thing I do know is that the drop down filter box will only hold a set number of entrys, cant remember how many exactly, but for example if the drop down box will only hold 100 entries and there are 150 unique entries in the column on which you are carrying out the filter it will only show the first 100, you could try sorting the column into a different order then having a look in the filter to see if your entry is there.

    I also know that it is not possible to change the number of entries the filter will hold.

    Hope that makes sense and helps you out
     
    Certifications: A+, 70-210, 70-290, 70-291
    WIP: 70-294
  6. MMaster

    MMaster New Member

    4
    0
    1
    Nelix

    AutoFiltering has a limit. Only the first 999 unique items in the column appear in the drop-down list. If your list exceeds this limit you will need to use advanced filtering.

    Alternatively, you could use the Custom option of the AutoFilter and type in the value that you need to filter for.

    HTH
     

Share This Page

Loading...