+ Reply to Thread
Results 1 to 5 of 5

hide rows automatically based on a value in that row

  1. #1
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    hide rows automatically based on a value in that row

    I posted this a few days ago, but I might have put it in the wrong place or something. Anyway, here is my issue:

    I have a spreadsheet we use to track the averages and rating of players in a league we manage. The spreadsheet has two tabs. The first computes the average each week, and the other tab takes data from the first to build a book we print weekly. To be in the book you need to have played at least 32 games. What I would like the second tab to do is to hide any row where the player has less than 32 games for me automatically. I know I can do it manually, but it seems we often miss one and have to reprint the book. Below is the spreadsheet i'm using.

    Thanks for your help!
    Attached Files Attached Files
    "Laugh? I thought I'd die!"

    Jimbo?

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: hide rows automatically based on a value in that row

    A simple "if" statement in a helper column together with an autofilter will do the trick.

    Let me know if it works for you

    Regards
    Alastair
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Re: hide rows automatically based on a value in that row

    I see how it should work (and it is PERFECT), but I can't figure out how to get the filter box at the top of the column. If I use the filter command it puts it at the top of each column and I would only want it on column F. I feel like this should be the easy part, but I am lost.

  4. #4
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Re: hide rows automatically based on a value in that row

    I figured it out! This works great!! Thank you very much!!

  5. #5
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: hide rows automatically based on a value in that row

    Glad to have been of assistance

    Alastair

+ 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