Help me to Build Formula

[farhan1194123]

Help me to Build Formula


example

Column A Column B

8


42



9


10


12

i want to copy in column B the value of parallel cell if the value in
col A is 9 then in col B it should 9. want to copy the formula down to get desire result.

 

[SteveO59L]

in b1 and filled down

=if(a1=9,9,"")

 

[farhan1194123]

Help me to Build Formula


example

Column A Column B

8


42



9


10


12

i want to copy in column B the value of parallel cell if the value in
col A is 9 then in col B it should 9. want to copy the formula down to get desire result.

there are some empty cells below after each value

 

[farhan1194123]

in b1 and filled down

=if(a1=9,9,"")

not working cos there are random values in col A

 

[RoryA]

Why do you just want a copy of column A in column B?

 

[farhan1194123]

Why do you just want a copy of column A in column B?

there is huge data set copy and paste takes long time
i have to copy and paste over and over gain
in Cell A1 suppose a Value of 9 a58 there is another value in between there are blanks
all i want is in col b i want B1 to B 58 is the value of cell A1 and in Cell B59 the value of A59 and the pattern goes down
hope you understand.

 

[RoryA]

I still don't see why you need to create a copy of the column using a formula, but you can just use

=IF(A1="","",A1)

 

[farhan1194123]

I still don't see why you need to create a copy of the column using a formula, but you can just use

=IF(A1="","",A1)

the formula would copy 9 in cell b1 but blank in b2 cos there is blank in a2 all i want is 9 in b1 to b58.
and in cell a59 there is another number which i want in b 59 to till there is a value in suppose a101 then b101 i want
the value of a101 and the sequence is goes down

 

[farhan1194123]

Link of sample sheet
https://drive.google.com/open?id=0BxDQ310Tvw5jUUE0M0xCcVprb1E

 

[RoryA]

I can't open that link, but I think you mean:

=IF(A1="","",A1)
in B1 and then
=IF(A2="",B1,A2)
in B2 and fill just B2 down.