Forum Discussion
Counting untill it is False, and continue
You're welcome to this big community. To your question, it is quite unclear.. Kindly re-work the question preferably with sample data.
Regards
well ... Im gonna type the same thing accually.
If the first cell is A, and the next below is also A, now what I want is to the next column a 2.
If the third cell is also A, I want a 3 in the next column.
If the fourth cell is B I want a 1 in the next column. Because it is the first B.
If the fifth cell is a A again then the next column puts an 1 again. So it count again.
If the 6 cell is a A again the next column needs a 2.
a 1
a 2
a 3
b 1
a 1
a 2
b 1
a 1
a 2
b 1
a 1
a 2
b 1
b 2
b 3
a 1
But I have number instead 4.00 and the -12.00.
- Your question is logical related.
Let say you have A, B, A, C in cells A1 to A4.
If cell B1, you can write an IF formula thus:
=IF(A1="A",1,IF(A1="B",2,3)). Click enter and copy down the formula.
What the above implies is that:
All cells with A in column A will return 1 in column B.
All cells with B in column A will return 2 in column B, and so on.
I guess that is what you're trying to achieve.COLUMNS A and B
A B
a
a
a 3
b
b 2
a 1
b 1
a 1
b 1
or something like this
A B
a 1
a 2
a 3
b 1
b 2
a 1
b 1
a 1
b 1
He is counting more if it is the same, if it is not the same start again. COUNTING IN A ROW, not the row in excel language, but we normally say count in a row.
Thank you for responding, I need this help really. Il wait for an answer
here is the data And I want B to fill with the result, as you can see we have 3 4.00 in the first 3 cells so in the B3 we need a 3, and from A4 to A7 we need a 4 in B7. And A8 To A9 we have again the same 4.00. So we need a 2 at B9. Thank you. Please help me with this
