View original (French)

Fill empty cell with the previous value

Yasn10 Posted messages 26 Status Membre -  
 HenriMOINE -
Hello everyone,

I have a column F with 60,000 rows, and in this column there are filled cells [02/2016 .....] and others that are empty. I would like a formula so that each empty cell takes the value from the cell above it.
Thank you for your time!!

Yansuje

4 réponses

Réponse 1 / 4
via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755
 
Hello

In another empty column, G for example, in G2 enter the formula =IF(F2="",F1,F2) and drag the formula to the bottom of the column
Then just copy this column and paste it in F using special paste Values only

Best regards
Via

--
"Imagination is more important than knowledge." A. Einstein
10
Yasn10 Posted messages 26 Status Membre
 
Hello,

Thank you for your quick response! It works, but I didn’t present my problem clearly. In fact, in the column, we find a cell filled with F4 and then 3 empty cells followed by another filled cell. I want to fill the 3 empty cells with the value that precedes them.

Best regards,

Yansuje
0
HenriMOINE
 
Hello,
That's exactly what I was looking for.
You have saved me a very precious commodity: time
Thanks again.
0