Subtracting from previous cell in column with data

[Rexy69]

Hi i have searched everywhere for this and i have found a few examples but they don't seem to work for me so thought i would try here !

basically i have a date column starting from B6 a profit column starting from C6 and a difference column starting from d6.

basically i have the dates for every date of the year but i wont have entries in every profit cell e.g

Date -----------Profit ------Difference
01/02/2019 ---£1000 -----£0.00
02/02/2019
03/02/2019
04/02/2019 ---£1,500 ----£500.00
05/02/2019
06/02/2019----£2,100 ----£600.00

I need the difference column to subtract the profit cell from the previous profit cell that has been entered, here is an example i found which looked like it was trying to solve the same issue but didnt work for me :

=IF(C6="","",IFERROR(C6-INDEX($C$6:C6,MATCH(1E+99,$C$6:C6)),C6))

This seems to just enter £0.00 next to each of the profit cells that has data and doesn't actually do a calculation to subtract from the last data cell

any help on this would be great

Thanks

Rexy~

 

[Ron Coderre]

Try this formula:

D6: =IF(C6="","",IFERROR(C6-LOOKUP(1E+99,$C$5:C5),N(C5)))

Does that help?

 

[Rexy69]

Try this formula:

D6: =IF(C6="","",IFERROR(C6-LOOKUP(1E+99,$C$5:C5),N(C5)))

Does that help?

it works perfectly !!! thanks very much !

Rexy~