Results 1 to 2 of 2

Thread: if an answer is correct copy question to different sheet

  1. #1

    if an answer is correct copy question to different sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    all,

    i have a questionaire that has yes/no answers basically i want some way of copying the question over to a different sheet if it answered yes so that on sheet 3 i will only have questions that were answered yes

    kind regards

    ricky

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,463
    Articles
    0
    Excel Version
    Excel 2016
    Assuming the questions are in Sheet1, starting in A2 down to A100, and the Yes/No replies are starting in B2 down to B100, then in the other sheet enter formula like:

    =IFERROR(INDEX(Sheet1!$A$2:$A$100,SMALL(IF(Sheet1!$B$2:$B$100="YES",ROW(Sheet1!$A$2:$A$100)-ROW(Sheet1!$A$2)+1),ROWS($A$2:$A2))),"")

    this formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER, then copy down as far as needed to get all possible YES results (i.e copy down 100 rows in this case).


Tags for this Thread

Posting Permissions

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