Hi all,

this problem to all of you may look trival, but I need some help with this.

I got the sheet in excel looking like this :

A B
Question
a) answer 1
b) answer 2
c) answer 3
d) answer 4

Question
a) answer 1
b) answer 2
c) answer 3
d) answer 4

and so on..

I need to put the numbers in the row A so they are in front of each
"Question". They should start with 1. and finish with the last "Question" in
the table.
The number of answers differ, there are 4 or 5 answers for the each
question.

Is this doable ?

Thanks in advance !

Elvis

Although this could be done with a macro (programming), I think you can
accomplish your goal much more easily with a formula.

put a 1 in column A next to your first question, then put this formula in
the next row in column A and copy it all the way down. This assumes your
first question starts in B1 (so this formula would be in A2); adjust the row
numbers accordingly.

=IF(B2="Question",MAX(B$1:B2)+1,"")

HTH,
Keith

"Elvis" wrote:

Hi all,

this problem to all of you may look trival, but I need some help with this.

I got the sheet in excel looking like this :

A B
Question
a) answer 1
b) answer 2
c) answer 3
d) answer 4

Question
a) answer 1
b) answer 2
c) answer 3
d) answer 4

and so on..

I need to put the numbers in the row A so they are in front of each
"Question". They should start with 1. and finish with the last "Question" in
the table.
The number of answers differ, there are 4 or 5 answers for the each
question.

Is this doable ?

Thanks in advance !

Elvis

Thanks for your answer, but the problem is - the contents of the "Question"
line is not a "Question" but it varies, just like all the answers too :)

ex.

A B
Which is the deepest loch in Scotland:
a) Loch Lomand
b) Loch Ness
c) Loch Morar
d) Loch Smith

What was the first of Earth's supercontinents:
a) Pangaea
b) Gondwanaland
c) Rodinia
...

I hope I explained the problem better now :)

"ker_01" wrote in message
...

Although this could be done with a macro (programming), I think you can
accomplish your goal much more easily with a formula.

put a 1 in column A next to your first question, then put this formula in
the next row in column A and copy it all the way down. This assumes your
first question starts in B1 (so this formula would be in A2); adjust the
row
numbers accordingly.

=IF(B2="Question",MAX(B$1:B2)+1,"")

HTH,
Keith

"Elvis" wrote:

Hi all,

this problem to all of you may look trival, but I need some help with
this.

I got the sheet in excel looking like this :

A B
Question
a) answer 1
b) answer 2
c) answer 3
d) answer 4

Question
a) answer 1
b) answer 2
c) answer 3
d) answer 4

and so on..

I need to put the numbers in the row A so they are in front of each
"Question". They should start with 1. and finish with the last "Question"
in
the table.
The number of answers differ, there are 4 or 5 answers for the each
question.

Is this doable ?

Thanks in advance !

Elvis

Thanks for your answer, but the problem is - the contents of the "Question"
line is not a "Question" but it varies, just like all the answers too :)

ex.

A B
Which is the deepest loch in Scotland:
a) Loch Lomand
b) Loch Ness
c) Loch Morar
d) Loch Smith

What was the first of Earth's supercontinents:
a) Pangaea
b) Gondwanaland
c) Rodinia
...

I hope I explained the problem better now :)



"ker_01" wrote in message
...
Although this could be done with a macro (programming), I think you can
accomplish your goal much more easily with a formula.

put a 1 in column A next to your first question, then put this formula in
the next row in column A and copy it all the way down. This assumes your
first question starts in B1 (so this formula would be in A2); adjust the
row
numbers accordingly.

=IF(B2="Question",MAX(B$1:B2)+1,"")

HTH,
Keith

"Elvis" wrote:

Hi all,

this problem to all of you may look trival, but I need some help with
this.

I got the sheet in excel looking like this :

A B
Question
a) answer 1
b) answer 2
c) answer 3
d) answer 4

Question
a) answer 1
b) answer 2
c) answer 3
d) answer 4

and so on..

I need to put the numbers in the row A so they are in front of each
"Question". They should start with 1. and finish with the last "Question"
in
the table.
The number of answers differ, there are 4 or 5 answers for the each
question.

Is this doable ?

Thanks in advance !

Elvis

My apologies for not fully understanding.

Ok, that complicates it, but not terribly. It sounds like you want to insert
a question # everywhere that the cell next to it is (a) not blank, and (b)
doesn't have a second character of ")"

=IF(AND(B2<"",mid(B2,2,1)<")"),MAX(A$1:A2)+1,"")

(also corrected the Max part of the expression, which needs to reference col
A not col B)

HTH,
Keith

"Elvis" wrote:

Thanks for your answer, but the problem is - the contents of the "Question"
line is not a "Question" but it varies, just like all the answers too :)

ex.

A B
Which is the deepest loch in Scotland:
a) Loch Lomand
b) Loch Ness
c) Loch Morar
d) Loch Smith

What was the first of Earth's supercontinents:
a) Pangaea
b) Gondwanaland
c) Rodinia
...

I hope I explained the problem better now :)



"ker_01" wrote in message
...
Although this could be done with a macro (programming), I think you can
accomplish your goal much more easily with a formula.

put a 1 in column A next to your first question, then put this formula in
the next row in column A and copy it all the way down. This assumes your
first question starts in B1 (so this formula would be in A2); adjust the
row
numbers accordingly.

=IF(B2="Question",MAX(B$1:B2)+1,"")

HTH,
Keith

"Elvis" wrote:

Hi all,

this problem to all of you may look trival, but I need some help with
this.

I got the sheet in excel looking like this :

A B
Question
a) answer 1
b) answer 2
c) answer 3
d) answer 4

Question
a) answer 1
b) answer 2
c) answer 3
d) answer 4

and so on..

I need to put the numbers in the row A so they are in front of each
"Question". They should start with 1. and finish with the last "Question"
in
the table.
The number of answers differ, there are 4 or 5 answers for the each
question.

Is this doable ?

Thanks in advance !

Elvis

I just tried to do as you suggested. I get the "The formula you typed
contains an error" when i try to paste the formula into A2. Did all the
steps u mentioned - put the number 1 in the A1, and the question text starts
from B1.

Any suggestions ?


"ker_01" wrote in message
...
My apologies for not fully understanding.

Ok, that complicates it, but not terribly. It sounds like you want to
insert
a question # everywhere that the cell next to it is (a) not blank, and (b)
doesn't have a second character of ")"

=IF(AND(B2<"",mid(B2,2,1)<")"),MAX(A$1:A2)+1,"")

(also corrected the Max part of the expression, which needs to reference
col
A not col B)

HTH,
Keith

"Elvis" wrote:

Thanks for your answer, but the problem is - the contents of the
"Question"
line is not a "Question" but it varies, just like all the answers too :)

ex.

A B
Which is the deepest loch in Scotland:
a) Loch Lomand
b) Loch Ness
c) Loch Morar
d) Loch Smith

What was the first of Earth's supercontinents:
a) Pangaea
b) Gondwanaland
c) Rodinia
...

I hope I explained the problem better now :)



"ker_01" wrote in message
...
Although this could be done with a macro (programming), I think you can
accomplish your goal much more easily with a formula.

put a 1 in column A next to your first question, then put this formula
in
the next row in column A and copy it all the way down. This assumes
your
first question starts in B1 (so this formula would be in A2); adjust
the
row
numbers accordingly.

=IF(B2="Question",MAX(B$1:B2)+1,"")

HTH,
Keith

"Elvis" wrote:

Hi all,

this problem to all of you may look trival, but I need some help with
this.

I got the sheet in excel looking like this :

A B
Question
a) answer 1
b) answer 2
c) answer 3
d) answer 4

Question
a) answer 1
b) answer 2
c) answer 3
d) answer 4

and so on..

I need to put the numbers in the row A so they are in front of each
"Question". They should start with 1. and finish with the last
"Question"
in
the table.
The number of answers differ, there are 4 or 5 answers for the each
question.

Is this doable ?

Thanks in advance !

Elvis

Sorry about the aircode error. This should work in cell A2.
:)

=IF(AND(B2<"",mid(B2,2,1)<")"),MAX(A$1:A1)+1,"")

This assumes that your actual "options" all have the close parenthesis
symbol as the second character in each of those cells; if you have something
different, like:

[space] a) <- where it is the third character, or
(a) <- again it is the third character

then you will have to change the MID parameters to match the location where
it is located.


"Elvis" wrote:

I just tried to do as you suggested. I get the "The formula you typed
contains an error" when i try to paste the formula into A2. Did all the
steps u mentioned - put the number 1 in the A1, and the question text starts
from B1.

Any suggestions ?


"ker_01" wrote in message
...
My apologies for not fully understanding.

Ok, that complicates it, but not terribly. It sounds like you want to
insert
a question # everywhere that the cell next to it is (a) not blank, and (b)
doesn't have a second character of ")"

=IF(AND(B2<"",mid(B2,2,1)<")"),MAX(A$1:A2)+1,"")

(also corrected the Max part of the expression, which needs to reference
col
A not col B)

HTH,
Keith

"Elvis" wrote:

Thanks for your answer, but the problem is - the contents of the
"Question"
line is not a "Question" but it varies, just like all the answers too :)

ex.

A B
Which is the deepest loch in Scotland:
a) Loch Lomand
b) Loch Ness
c) Loch Morar
d) Loch Smith

What was the first of Earth's supercontinents:
a) Pangaea
b) Gondwanaland
c) Rodinia
...

I hope I explained the problem better now :)



"ker_01" wrote in message
...
Although this could be done with a macro (programming), I think you can
accomplish your goal much more easily with a formula.

put a 1 in column A next to your first question, then put this formula
in
the next row in column A and copy it all the way down. This assumes
your
first question starts in B1 (so this formula would be in A2); adjust
the
row
numbers accordingly.

=IF(B2="Question",MAX(B$1:B2)+1,"")

HTH,
Keith

"Elvis" wrote:

Hi all,

this problem to all of you may look trival, but I need some help with
this.

I got the sheet in excel looking like this :

A B
Question
a) answer 1
b) answer 2
c) answer 3
d) answer 4

Question
a) answer 1
b) answer 2
c) answer 3
d) answer 4

and so on..

I need to put the numbers in the row A so they are in front of each
"Question". They should start with 1. and finish with the last
"Question"
in
the table.
The number of answers differ, there are 4 or 5 answers for the each
question.

Is this doable ?

Thanks in advance !

Elvis