View original (French)

OFFSET function if cell is empty

vie66 -  
yclik Posted messages 75 Registration date   Status Member Last intervention   -

Hello everyone,

I want to do something simple, but I don't know enough about Excel formulas. In fact, I have a table with 5 columns and about 15 rows. The ones I'm interested in are columns C and D.

I want column C to take the last number entered in column D, but if the row is empty, column C of the next row should take that same number.

I hope I'm clear enough? I'm really a novice with formulas.

Thank you

3 answers

  1.
    yclik Posted messages 75 Registration date   Status Member Last intervention   1 612
     

    Good evening

    An example should be attached as there is missing information.

    Can there be multiple blank lines?

    Below, to attach a spreadsheet, the procedure of Raymond whom I greet in passing.

      1) Go to https://www.cjoint.com/ 2) Click on [Browse] to select the file (15 MB max) 3) Scroll down to click on the blue button [Create the Cjoint link] 4) After a few seconds, the second page appears, with the link in bold; right-click on it and choose "Copy link" 5) Return to the discussion on CCM, and in your message, do "Paste".
    1
  2. yclik Posted messages 75 Registration date   Status Member Last intervention   1 612
     

    Good evening

    To test

    If date entered in column A

    Formula to copy down

     =IF(A4="","",MAX(D$3:D3))
    1
  3. vie66
     

    https://www.cjoint.com/c/LHtsszHpzZc

    Here is the link for my example

    0