Q: macro - enumerating in excel
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
|