View original (French)

Fill empty cell with the previous value

Yasn10 Posted messages 26 Status Member -  
 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 answers

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    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
    1. Yasn10 Posted messages 26 Status Member
       
      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
    2. HenriMOINE
       
      Hello,
      That's exactly what I was looking for.
      You have saved me a very precious commodity: time
      Thanks again.
      0