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
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
Which are the columns that you use? In which column exist the YES, text?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
hi,
my column will be H that will contain the Yes/NO answers and i want them to paste the questions to sheet3 column A
thnk you
ARRAY formula. Copy down and across.
=INDEX(Sheet1!G$2:G$20,SMALL(IF(Sheet1!$H$2:$H$20="yes",ROW(Sheet1!G$2:G$20)-1),ROW(Sheet1!G1)))
-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.
Last edited by Fotis1991; 09-09-2013 at 09:48 AM.
Hi,
im sorry to be a pain.
My questions are in sheet one column A my answers are in sheet1 column H and based upon column H's yes answers i want the questions from column A copied to sheet3
hope this clears it up if you need any more info please let me know![]()
thank you again!
ricky
Just change the column in INDEX part of the formula.
=INDEX(Sheet1!a$2:a$20,SMALL(IF(Sheet1!$H$2:$H$20="yes",ROW(Sheet1!a$2:a$20)-1),ROW(Sheet1!a1)))
worked well thank you
You are welcome.
Feedback is always appreciated from the people that spend time trying to help you!
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks