View original (French)

Copy cell above

mika1616 Posted messages 1 Status Membre -  
DjiDji59430 Posted messages 4277 Registration date   Status Membre 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 réponse

Réponse 1 / 1
DjiDji59430 Posted messages 4277 Registration date   Status Membre Last intervention   716
 
Hello,

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

Regards
2