View original (French)

OFFSET function if cell is empty

vie66 -  
yclik Posted messages 69 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

Answer 1 / 3
yclik Posted messages 69 Registration date   Status Member Last intervention   1 607
 

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
Answer 2 / 3
yclik Posted messages 69 Registration date   Status Member Last intervention   1 607
 

Good evening

To test

If date entered in column A

Formula to copy down

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

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

Here is the link for my example
0