+ Reply to Thread
Results 1 to 5 of 5

list of projects, want only the "N" answers in order in a another sheet

  1. #1
    Registered User
    Join Date
    07-26-2007
    Posts
    9

    list of projects, want only the "N" answers in order in a another sheet

    I Guys

    I have a list of projects that are in evaluation in 15 different criteria: Y ou N.

    I would like that the same projects in a different sheet would have only the names of evaluation criteria witch the responses where “N” in a line order.

    I attach a file with the example.

    THANK YOU IN ADVANCE!!!

    croque
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    See attached... sheet3.

    Note: I added a helper column to Sheet 1 to identify rows containing N's. This is used in formulas in Sheet3 to generate list.

    Note2: Formulas in Sheet3 are array formulas which are confirmed with CTRL+SHIFT+ENTER instead of just ENTER. The {} brackets are auto-generated by Excel...
    Attached Files Attached Files
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    07-26-2007
    Posts
    9

    I didn’t explain myself correctly

    Perhaps I didn’t explain myself correctly.

    If you see sheet2 of the file I pretend that each project have in the horizontal line every “evaluation criteria name” that are connect with an evaluation “N”.

    For example if you see project 007-00001-1 I gave “N” in evaluation criteria 1; 4,9; and 13;

    And is that criteria name, in order, that I want in the second sheet.

    Thanks in advance

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Ok then....

    see attached.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-26-2007
    Posts
    9

    Smile Thanks !!!

    Many thanks ... works in perfection!!

+ 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