Formula to delete rows based on "Answer: ?"

[blahbleh]

Hi I almost gave up searching when I registered to post this question. Please help me.

I have these rows for example:
[TABLE="width: 658"]
<tbody>[TR]
[TD]2) What are profits?[/TD]
[/TR]
[TR]
[TD]A) Total money taken in by a corporation[/TD]
[/TR]
[TR]
[TD]B) Increases in income from year to year[/TD]
[/TR]
[TR]
[TD]C) Increases in a corporation's stock price[/TD]
[/TR]
[TR]
[TD]D) Revenue generated by goods and services[/TD]
[/TR]
[TR]
[TD]E) Difference between revenues and expenses[/TD]
[/TR]
[TR]
[TD]Answer: E[/TD]
[/TR]
</tbody>[/TABLE]

What I am trying to do here is to find a formula that deletes all the rows that are not the correct answer,above the last row, which contains the correct answer. This is where I got so far and it could be a completely incorrect approach.

=IF(A11=Answer: a, FIND("A) *",A6))

Best scenario it deletes even the answer row after it finished searching.

Thank you

 

[Special-K99]

Formulas cannot delete rows.
Formulas can produce a value based on other cells but there is no formula to delete a cell.
You need VBA to delete cells/rows.

You could use Condtional Formatting to highlight the row with the correct answer. To do this you would need some form of table that contained a list of questions and their correct answers.
But it still wouldnt delete the wrong rows.

 

[blahbleh]

Formulas cannot delete rows.
Formulas can produce a value based on other cells but there is no formula to delete a cell.
You need VBA to delete cells/rows.

You could use Condtional Formatting to highlight the row with the correct answer. To do this you would need some form of table that contained a list of questions and their correct answers.
But it still wouldnt delete the wrong rows.

I appreciate your time Special-K99!