+ Reply to Thread
Results 1 to 3 of 3

return results without skipping lines.

  1. #1
    Registered User
    Join Date
    01-05-2009
    Location
    Southern Pines, NC
    MS-Off Ver
    Excel 2007
    Posts
    95

    return results without skipping lines.

    I have attached a file. I need to create a new sheet (sheet 2) that will return Column A of sheet 1 (Name) if Column B (Value) = "yes". However, I do not want to skip lines if the value = "No".

    The desired results are shown in sheet 3. How do I write a formula in Sheet 2 that will do this.

    thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: return results without skipping lines.

    Hmmm ...

    Looks to me that if you filter Sheet1 > Values = Yes

    Then copy the result to whatever sheet you wish, would get your the desired result.

    Am I missing something? Or is there more to the problem?
    Last edited by Marcol; 07-13-2010 at 05:30 AM. Reason: Typo

  3. #3
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: return results without skipping lines.

    If real life is more complex (I would expect) you may find pivot tables useful.
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

+ 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