Copy data of the last entry

[Manolocs]

Hi, I have to make some calculations using the last row of the inserted data. Need to be as formulas not macro neither VBA.
Any help is more than welcome.
In the next day will be more data that have to replace the ones in line 2.

[TABLE="width: 500"]
<tbody>[TR]
[TD]total[/TD]
[TD][/TD]
[TD]potatoes [/TD]
[TD]tomato[/TD]
[TD]apple[/TD]
[/TR]
[TR]
[TD]this line should copy automatically the last inserted data row.[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]time[/TD]
[TD]potatoes [/TD]
[TD]tomato[/TD]
[TD]apple[/TD]
[/TR]
[TR]
[TD]1 mar 18[/TD]
[TD]09:00[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]2 mar 18[/TD]
[TD]09:45[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]2 mar 18[/TD]
[TD]17:00[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[steve the fish]

Try like this:

=LOOKUP(9.9E+307,C:C)

 

[Manolocs]

Great, Thank you Steve the fish, exactly what I need.