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!