/-_-b wrote:
I got this file with the trivia questions and answers.

The sheet in excel looks something like this :

A column :
Question 1
a) Answer 1
b) Answer 2
c) Answer 3
d) Answer 4

Question 2
a) Answer 1
b) Answer 2
...

B column :
+ mark in the row where the answer to the question is right.


My question is : can I make a new sheet with the question numbers and the
right answers only ? It should look something like this :

1 a
2 b
3 d
4 c
5 d
...

Ty all in advance !

Marko

Hi Marko,

This formula on the other sheet might work (assuming sheet with
Questions and Answers is Sheet1)...

=ROWS($1:1) &CHOOSE(MATCH("+",INDIRECT("Sheet1!B"&MATCH("Quest ion
"&ROWS($1:1),Sheet1!$A:$A,0)+1&":B"&MATCH("Questio n
"&ROWS($1:1),Sheet1!$A:$A,0)+4),0),"a","b","c","d" )

Ken Johnson