+ Reply to Thread
Results 1 to 4 of 4

Wildcard filter problem

  1. #1
    Registered User
    Join Date
    04-07-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    16

    Wildcard filter problem

    I am attempting to find thousandths and ten-thousandth values by filtering large files. Let's say I want to find all cells within a column that contain a thousandth or ten thousandth spot. I have tried using techniques such as a custom filter with the line *.??1 or *.???1 to filter to cells that need special, arbitrary rounding. Unfortunately due to the nature of what I'm doing, I can't just use the round function because I will be pennies off, which prevents the file from uploading to the general ledger. Any ideas on how to make the filter function find only cells that contain thousandth and ten thousandth characters in the decimal spot? Any help would be appreciated!

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Wildcard filter problem

    I would use a "helper" column. If column A has the values, then in another column:

    =10000*(A1-ROUND(A1,2))>0

    The "helper" column will show TRUE is the value in column A contains thousands or ten thouands
    Gary's Student

  3. #3
    Registered User
    Join Date
    04-07-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Wildcard filter problem

    That's a good idea. I was just curious if there is any way to get the filter to pick up wildcards. But thank you very much. I know your technique will work. Thank you so much

  4. #4
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Wildcard filter problem

    The wildcard concept is attractive; however, it is too dependent on the format of the cells as opposed to the value of the cells

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1