Formula to autofill values in B with condition from A

[bettlejus]

Hi,

I cannot figure the formula logic for the following operation:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]CRT[/TD]
[TD]STATUS[/TD]
[TD]Desired Result[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]P1[/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]P2[/TD]
[TD]P2[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]P2[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]P2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]P3[/TD]
[TD]P3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]P3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]P3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]P3[/TD]
[/TR]
</tbody>[/TABLE]


I have a count in column A, that is the same untill a value changes in B, like 1..1..1..for P1 and I want a formula that will fill column B to look just like column C, fill the first value untill number in column A changes.

Can you guys help me out?

Thank yoU!

 

[Joe4]

Did you try the methods contained in the link I provided?
I have used that method many times (and on older versions of Excel too).