sum difference between 2 months for various meter readings

D

Deanius

New Member
Joined
Mar 12, 2017
Messages
14
Hi

I want to know if there is a way of showing the difference between two numbers between one month and the next for multiple serial numbers

below shows one serial number with a running total for the device monthly. There would be other serial numbers in the mix also. I need too know the difference between each month per device.

the differnence between Nov/16 and Dec/16 total count is 6896 so i'd need 6896 to be in the Nov/16 row for the serial number A5C2121008007

Hope this makes sense. Thanks in advance.

Dean

'A5C2121008007
'A5C2121008007
'A5C2121008007
'A5C2121008007
'A5C2121008007
'A5C2121008007

<colgroup><col style="mso-width-source:userset;mso-width-alt:3516;width:78pt" width="104"> <col style="mso-width-source:userset;mso-width-alt:2991;width:67pt" width="89"> <col style="mso-width-source:userset;mso-width-alt:3193;width:71pt" width="95"> <col style="mso-width-source:userset;mso-width-alt:3314;width:74pt" width="98"> <col style="width:50pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:3072;width:68pt" width="91"> </colgroup><tbody>
[TD="width: 104"]Serial Number
[/TD]
[TD="width: 89"]Total Count[/TD]
[TD="width: 95"]Mono Count[/TD]
[TD="width: 98"]Colour Count[/TD]
[TD="width: 67"]Scans[/TD]
[TD="class: xl65, width: 91"]Date[/TD]

[TD="align: right"]141422[/TD]
[TD="align: right"]72214[/TD]
[TD="align: right"]69208[/TD]
[TD="align: right"]10440[/TD]
[TD="class: xl65, align: right"]01/11/2016[/TD]

[TD="class: xl70"]'A5C2121008007[/TD]
[TD="class: xl71, align: right"]148318[/TD]
[TD="class: xl71, align: right"]75996[/TD]
[TD="class: xl71, align: right"]72322[/TD]
[TD="class: xl71, align: right"]10969[/TD]
[TD="class: xl76, align: right"]01/12/2016[/TD]

[TD="align: right"]157247[/TD]
[TD="align: right"]80815[/TD]
[TD="align: right"]76432[/TD]
[TD="align: right"]11793[/TD]
[TD="class: xl65, align: right"]01/01/2017[/TD]

[TD="class: xl66"]'A5C2121008007[/TD]
[TD="class: xl66, align: right"]164505[/TD]
[TD="class: xl66, align: right"]84302[/TD]
[TD="class: xl66, align: right"]80203[/TD]
[TD="class: xl66, align: right"]12459[/TD]
[TD="class: xl69, align: right"]01/02/2017[/TD]

[TD="align: right"]171779[/TD]
[TD="align: right"]87893[/TD]
[TD="align: right"]83886[/TD]
[TD="align: right"]13145[/TD]
[TD="class: xl65, align: right"]01/03/2017[/TD]

[TD="align: right"]179529[/TD]
[TD="align: right"]91605[/TD]
[TD="align: right"]87924[/TD]
[TD="align: right"]13792[/TD]
[TD="class: xl65, align: right"]01/04/2017[/TD]

[TD="align: right"]188118[/TD]
[TD="align: right"]96094[/TD]
[TD="align: right"]92024[/TD]
[TD="align: right"]14546[/TD]
[TD="class: xl65, align: right"]01/05/2017[/TD]

[TD="align: right"]197671[/TD]
[TD="align: right"]100801[/TD]
[TD="align: right"]96870[/TD]
[TD="align: right"]15562[/TD]
[TD="class: xl65, align: right"]01/06/2017[/TD]

[TD="class: xl66"]'A5C2121008007[/TD]
[TD="class: xl66, align: right"]206846[/TD]
[TD="class: xl66, align: right"]105177[/TD]
[TD="class: xl66, align: right"]101669[/TD]
[TD="class: xl66, align: right"]16522[/TD]
[TD="class: xl69, align: right"]01/07/2017[/TD]

[TD="class: xl66"]'A5C2121008007[/TD]
[TD="class: xl66, align: right"]215118[/TD]
[TD="class: xl66, align: right"]109483[/TD]
[TD="class: xl66, align: right"]105635[/TD]
[TD="class: xl66, align: right"]17129[/TD]
[TD="class: xl69, align: right"]01/08/2017[/TD]

[TD="class: xl66"]'A5C2121008007[/TD]
[TD="class: xl66, align: right"]223532[/TD]
[TD="class: xl66, align: right"]113748[/TD]
[TD="class: xl66, align: right"]109784[/TD]
[TD="class: xl66, align: right"]17676[/TD]
[TD="class: xl69, align: right"]01/09/2017[/TD]

[TD="class: xl66"]'A5C2121008007[/TD]
[TD="class: xl66, align: right"]231728[/TD]
[TD="class: xl66, align: right"]117677[/TD]
[TD="class: xl66, align: right"]114051[/TD]
[TD="class: xl66, align: right"]18366[/TD]
[TD="class: xl69, align: right"]01/10/2017[/TD]

[TD="class: xl66"]'A5C2121008007[/TD]
[TD="class: xl66, align: right"]240447[/TD]
[TD="class: xl66, align: right"]121865[/TD]
[TD="class: xl66, align: right"]118582[/TD]
[TD="class: xl66, align: right"]19180[/TD]
[TD="class: xl69, align: right"]01/11/2017[/TD]

[TD="class: xl66"]'A5C2121008007[/TD]
[TD="class: xl66, align: right"]245792[/TD]
[TD="class: xl66, align: right"]124579[/TD]
[TD="class: xl66, align: right"]121213[/TD]
[TD="class: xl66, align: right"]19661[/TD]
[TD="class: xl69, align: right"]01/12/2017[/TD]

[TD="class: xl66"]'A5C2121008007[/TD]
[TD="class: xl66, align: right"]255086[/TD]
[TD="class: xl66, align: right"]129047[/TD]
[TD="class: xl66, align: right"]126039[/TD]
[TD="class: xl66, align: right"]20247[/TD]
[TD="class: xl69, align: right"]01/01/2018[/TD]

[TD="class: xl66"]'A5C2121008007[/TD]
[TD="class: xl66, align: right"]263910[/TD]
[TD="class: xl66, align: right"]133841[/TD]
[TD="class: xl66, align: right"]130069[/TD]
[TD="class: xl66, align: right"]20851[/TD]
[TD="class: xl69, align: right"]01/02/2018[/TD]

[TD="class: xl66"]'A5C2121008007
[/TD]
[TD="class: xl66, align: right"]271674[/TD]
[TD="class: xl66, align: right"]137464[/TD]
[TD="class: xl66, align: right"]134210[/TD]
[TD="class: xl66, align: right"]21581[/TD]
[TD="class: xl69, align: right"]01/03/2018[/TD]

</tbody>

<tbody>
[TD="class: xl70, width: 91"][/TD]
[TD="class: xl70, width: 96"][/TD]
[TD="class: xl70, width: 100"][/TD]
[TD="class: xl70, width: 67"][/TD]
[TD="class: xl71, width: 79"][/TD]

[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]

[TD="class: xl67, align: right"][/TD]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]

[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]

[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]

[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="class: xl69, align: right"][/TD]

[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="class: xl69, align: right"][/TD]

[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]

[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]

[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]

[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]

[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]

[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]

[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]

[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]

[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl65, align: right"][/TD]
[TD="class: xl66, align: right"][/TD]

</tbody>
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Sort by date Sort by votes
something like this should do ti. I have assume the last row is 200

=INDEX(B2:B$200,MATCH(A2,A3:A$200,0))-B2
 
Upvote 0
You must log in or register to reply here.

Similar threads

O
  • Question Question
Survey data to capture full month
Replies
5
Views
879
DanteAmor
DanteAmor
C
  • Question Question
Sum
Replies
3
Views
1K
pbornemeier
pbornemeier
B
  • Question Question
Count number of months per year between two dates
2
Replies
11
Views
1K
DanteAmor
DanteAmor
A
  • Question Question
Add Sequence numbers Based on Dates
Replies
1
Views
3K
Jeffrey Mahoney
Jeffrey Mahoney
C
  • Question Question
Number of working days per month between 2 Dates
Replies
4
Views
884
CurrentHamster
C

Forum statistics

Threads
1,223,896
Messages
6,175,265
Members
452,627
Latest member
KitkatToby

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top