+ Reply to Thread
Results 1 to 3 of 3

Adv Filter criteria, true false, vs 1 and 0

  1. #1
    Registered User
    Join Date
    08-31-2007
    Posts
    2

    Adv Filter criteria, true false, vs 1 and 0

    I have trouble running advance filter with true false criteria results. I have a spreadsheet I started years ago showing criteria fields with 1 and 0, and filtering works great.

    When I copy this spreadsheet to new blank worksheet, the criteria field shows up as true and false, and the filtering doesn't work. Does anyone know what determines true/false in cells, versus 1 and 0's? This failure to filter on new spreadsheets is driving me up a wall.

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    What formulas are you using?

  3. #3
    Registered User
    Join Date
    08-31-2007
    Posts
    2
    =AND(H2>(H$88-1.55*H$98),H2<(H$88+1.55*H$98))

    H88 is 44.2 (2007 July Temp)
    H98 is 2.4 (July Standard Deviation)
    H2 is JULT (or July Temperature)

    I am searching all the years from 1921 to 2007 that have July temperatures in the range of 44.2 plus or minus 2.4 degrees (Times 1.55).

    Typical:
    YEAR JANT FEBT MART APRT MAYT JUNT JULT
    1921 -17.9 -19.4 -14.4 -2.4 19.0 32.2 42.3
    1922 -7.5 -14.7 -15.4 0.4 11.6 31.7 35.2
    1923 -24.1 -14.2 -21.0 -1.4 21.5 34.1 41.2

    2007 -15.7 -9.7 -15.3 8.3 16.7 36.0 44.2


    As I say, it filters in the current spreadheet with 1 and 0's, not in the new spreadsheet showing true and false. It should at least return the 2007 row of information.
    YEAR JANT FEBT MART APRT MAYT JUNT JULT
    TRUE TRUE TRUE FALSE TRUE FALSE TRUE
    Last edited by Larryr8732; 08-31-2007 at 12:22 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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