Select Rows Based on Cell Value

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

Thread: Select Rows Based on Cell Value

  1. #1
    New Member
    Join Date
    Oct 2009
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Select Rows Based on Cell Value

     
    Hi

    New to Excel.

    I need to select all the rows in sheet 1 where a cell is equal to or less than a certain value and then show all those rows in sheet 2. Can you please show me a simple way to do this?

    Example:
    Each row in sheet 1 has a cell that shows the number of days left before expiration of an event. The number of days in that cell is calculted with a formula. I want to select all the rows where the days left are less than 60 and then show all those rows in another sheet.

    Thanks
    Adrian
    0 0
     

  2. #2
    MrExcel MVP
    Join Date
    Mar 2004
    Location
    Canada
    Posts
    17,769
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Select Rows Based on Cell Value

      
    Try using 'Advanced Filter'...

    http://www.contextures.com/xladvfilter01.html
    0 0
     

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
  •  

 

 
DMCA.com