MS Excel 2003 Question

Discussion in 'Windows Desktop Systems' started by kcnychief, Jan 20, 2006.

  1. kcnychief

    kcnychief █▄█ ▀█▄ █ Political User Folding Team

    Messages:
    16,948
    Location:
    Massachusetts
    I have a spreadsheet with like 30 columns. Say, for instance, column H and I are sometimes the same numeric value, and sometimes they are not. I have about 200+ rows.

    What I am looking to do, is out of those 200+ rows, hide the row(s) that have H and I as an equal value. Say if H has 50 and I has 50, hide the entire row. If H has 49 and I has 50, show that row.

    Is that even possible?
     
  2. rushm001

    rushm001 In the beginning...... Political User

    Messages:
    3,480
    Location:
    Norfolk, UK
    I'm sure it is possible with Visual Basic, but no idea how you'd go about it sorry. :(
     
  3. sean.ferguson

    sean.ferguson Moderator Folding Team

    Messages:
    1,693
    Location:
    Fife; Scotland
    Is Auto Filter what your talking about?

    This will work with columns which have headers at the top and data following underneath, select all then select AutoFilter from the Filter menu in the Data Menu. If this isnt what you want, then it can be turned off again be re-selecting Autofilter. :)
     
  4. VenomXt

    VenomXt Blame me for the RAZR's Folding Team

    Messages:
    3,453
    Location:
    Houston, Texas
    Auto filter is what you want.
     
  5. jimi_81

    jimi_81 Moderator Political User

    Messages:
    820
    Location:
    Stoney Creek, ON, Canada
    mrexcel.com bro!
     
    kcnychief likes this.
  6. kcnychief

    kcnychief █▄█ ▀█▄ █ Political User Folding Team

    Messages:
    16,948
    Location:
    Massachusetts
    AutoFilter, while a good feature, doesn't have the muscle for my particular request. That would work if it were a specific range I wanted, but since each of the 200+ rows is different, I need something better.

    I just signed up for the mrexcel forum, will post back if I come across anything. I fear VB may be the course of action...
     
  7. VenomXt

    VenomXt Blame me for the RAZR's Folding Team

    Messages:
    3,453
    Location:
    Houston, Texas
    and fear you should... lol id be intrested to know what you find either way.
     
  8. kcnychief

    kcnychief █▄█ ▀█▄ █ Political User Folding Team

    Messages:
    16,948
    Location:
    Massachusetts
    That forum was a good recommendation, here is what they recommended:

    Take any available column, in my case it was column "S"

    In S2 (since first data was in H2 and I2), I put "=H1=I1", which returned a value of TRUE

    I then did an autofilter and selected only FALSE

    woo :)

    reps jimi!