Darin,

Using VBA, you can filter your data to show only "No" values, then copy
visible cells from the table and paste elsewhere.

Or you can use a table of rather complicated formulas to extract only the
values associated with "No" entries.

Do you have a preference?

HTH,
Bernie
MS Excel MVP

"Darin Kramer" wrote in message
...
Hi there,

Within a workbook, three columns of data
Column 1 - Question number
Column 2 - Quest Description
Column 3 - Answer

There are 50 questions
Answers can only be yes or no

I need to know for all the NO answers, the question number and the
question description (in a neat format, ie one after each other)
I can write a normal If statement, but that will list the answers on
rows 1 to 50 (with blank lines inbetween where the answer is yes), I
need all the answers together somewhere else in the workbook, one after
each other...

Thanks and Regards



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!