Formula

Andries

I Have a sheet that collects, via form, all the diesel issued to our equipment. I have a column that needs to look at the previous hours for the specific equipment number, but my formula only looks 1 entry back, and should continuously look back. My formula looks like this;

=INDEX(COLLECT([km/Hour]:[km/Hour], [Job #]:[Job #], [Job #]@row), 2)

Please assist

Paul Newcome

Are you able to provide some screenshots for context?