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
