Formula for finding out the difference between first and last entry of the day.

[Ashish Balki]

My data is like following

Date Month Wh(I)
01.06.2016 June 37296.8
01.06.2016 June 37297.2
01.06.2016 June 37297.4
01.06.2016 June 37297.8
01.06.2016 June 37298
01.06.2016 June 37298
01.06.2016 June 37298.6
01.06.2016 June 37298.6
01.06.2016 June 37298.8
01.06.2016 June 37299
01.06.2016 June 37299.2
01.06.2016 June 37299.2
01.06.2016 June 37299.4
01.06.2016 June 37299.4
01.06.2016 June 37299.4
01.06.2016 June 37299.4
01.06.2016 June 37299.6
01.06.2016 June 37300
01.06.2016 June 37300
01.06.2016 June 37300.2
01.06.2016 June 37300.4
01.06.2016 June 37300.6
01.06.2016 June 37301
02.06.2016 June 37301.2
02.06.2016 June 37301.6
02.06.2016 June 37301.6
02.06.2016 June 37302
02.06.2016 June 37302.2
02.06.2016 June 37302.4
02.06.2016 June 37302.6
02.06.2016 June 37303.2
02.06.2016 June 37307
02.06.2016 June 37309.8
02.06.2016 June 37316.4
02.06.2016 June 37320.4
02.06.2016 June 37321
02.06.2016 June 37324.4
02.06.2016 June 37326
02.06.2016 June 37331.6
02.06.2016 June 37335.2
02.06.2016 June 37337.6
02.06.2016 June 37341
02.06.2016 June 37342.8
02.06.2016 June 37345.2
02.06.2016 June 37345.4
02.06.2016 June 37345.6
03.06.2016 June 37346
03.06.2016 June 37346.2
03.06.2016 June 37346.6
03.06.2016 June 37346.8
03.06.2016 June 37346.8
03.06.2016 June 37347.4
03.06.2016 June 37347.6
03.06.2016 June 37347.6
03.06.2016 June 37352
03.06.2016 June 37357.6
03.06.2016 June 37363
03.06.2016 June 37364.6
03.06.2016 June 37370.2
03.06.2016 June 37371
03.06.2016 June 37376
03.06.2016 June 37378.6
03.06.2016 June 37382
03.06.2016 June 37383.4
03.06.2016 June 37386.4
03.06.2016 June 37388.2
03.06.2016 June 37388.4

 

[Ashish Balki]

This list is endless.
Would appreciate if someone posts a formula for doing the same

 

[rahulshewale1]

hiii,


is this you looking for............?



Thanks
rahul shewale

 

[bosco_yip]

In F2, formula copy down :

=SUM(VLOOKUP(E2,$A$2:$C$1000,3,N(IF(1,{0;1})))*{-1;1})

Regards
Bosco

 

[Ashish Balki]

Thanks Bosco and Rahul.

You guys have been of great help.
This is exactly what i was looking for.

I also figured it out that this can be done by indexing and match function as well.