Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: hide rows

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Athens Greece
    Posts
    149
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hallo! Me again!
    I have 2 columns A & B. On col. A i have either "o", "r" or "p" and on col. B there are numbers. I have a formula to get totals depending what col. A indicates (it's a SUMIF formula where if cell C1 = "r" I get the sum of all rows in col. A that have "r" & "p"). The question is: If the total comes up from the cells in col. A that have "r" & "p", Is it possible to automatically hide all other rows ??

    Thanks once more

  2. #2
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,053
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Use Data-Filter-Advanced Filter.

    First, set up a criteria. In a cell, input the column heading for the column with the r, p & o designations. in the cell below the column heading, input r. In the cell below that, input p. Then name the 3-cell range. Use that name in the Advanced Filter process when asked for the criteria.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Athens Greece
    Posts
    149
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks. I did it and worked

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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