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.

 

[farhan1194123]

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.

Bravo...!!!!!
that is exactly i want sir thank you so much