Reputation: 31
Friends i need a excel formal, struggling for some thing like this form past few days :(
it should search for the value in which starts with `01` in `B row`
and past that value in `A1,A2,A3,A4.......` till it got another value in `B row`
which stars with `01`.
B1
will start with 01
for 100%so after B1
if B27
has a value starting with 01
, this formal should copy the B1
value from A1
to A26
from A27
it should past the value of B27
(from A27
to some other cell in B row which starts with 01
)
Upvotes: 0
Views: 278
Reputation: 71598
Your English could be better ^^;
Anyway, if I understand well, it seems to me that a simple IF()
would suit you.
In A2
, put:
=IF(LEFT(B2,2)="01",B2,A1)
In A1
, just put the value of B1
yourself since the formula can't reference to cell A0
.
Then just drag down the formula.
Upvotes: 1