View original (French)

Copy cell above

mika1616 Posted messages 1 Status Member -  
DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   -
Hello
I have an Excel file that contains 111,000 rows
but I have empty cells that I need to copy from the cell above, and sometimes there are 3 empty cells in a row????

I don't know how to do that with a formula??

1 answer

  1.
    DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
     
    Hello,

    your list starts in A2
    in B2 =A2
    in B3 =IF(A3="";A2;A3)

    Regards
    2