• Autofilter, custom filter (Win XP Excel 2003)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Autofilter, custom filter (Win XP Excel 2003)

    Author
    Topic
    WSgsmith
    AskWoody Lounger
    July 9, 2005 at 12:55 pm #421660

    When I try to use the Autofilter feature to find records greater than a salary, I get erratic results. For example, I look for a number greater than x, and I get a blank sheet! If I sort the list in assending order and than look for top 10, it functions correctly. If I modify the value in the custom order window for the top 10, once again I get all blanks.

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      July 9, 2005 at 1:22 pm #958779

      Could it be that the values are interpreted as text? This can happen if the values have been imported from another application.
      First, check that the relevant cells haven’t been formatted as Text in the Number tab of Format | Cells…
      If this is not the case, try the following:
      – Select an empty cell.
      – Copy it to the clipboard (Edit | Copy)
      – Select the problem cells.
      – Select Edit | Paste Special…
      – Click the Add option, then click OK.
      This should convert values interpreted as text to numbers.

      If this doesn’t help, could you post a scaled down copy of the workbook?

      Reply | Quote
      • WSgsmith
        AskWoody Lounger
        July 9, 2005 at 11:48 pm #958864

        The some columns had a special monetary format. I replaced it with general format and it works fine. As usual, thank you.

        Reply | Quote
        • WSAladin Akyurek
          AskWoody Lounger
          July 10, 2005 at 7:04 am #958880

          Since you are on Excel 2003, convert the area you autofilter to a list by means of Data|List|Create List. The list functionality includes AutoFilter along with significant options.

          Reply | Quote
    Viewing 0 reply threads
    Reply To: Autofilter, custom filter (Win XP Excel 2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    March 2025
    S M T W T F S
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.