Spreadsheet: 877044d1723724325-count-duplicates-in-column-peakoverload-duplicates2-365-aligw
Sheet: Sheet1

 |  |  |  | Using The Formula Supplied
 | TB Number | Duplicate Instance |  | Number of Duplicates
 | 00306
 | 000309 | 1 |  |  |  |  | 309
 | 00309 |  |  | The Result Should Be |  |  | 309
 | 00310 |  |  | Number of Duplicates | 47 |  | 310
 | 01695 |  |  |  |  |  | 1695
 | 001700 | 2 |  |  |  |  | 1700
 | 01700 |  |  |  |  |  | 1700
 | 01701 |  |  |  |  |  | 1701
 | 02715 |  |  |  |  |  | 2715
 | 002732 | 3 |  |  |  |  | 2732
 | 02732 |  |  |  |  |  | 2732
 | 02742 |  |  |  |  |  | 2742
 | 007881 | 4 |  |  |  |  | 7881
 | 07881 |  |  |  |  |  | 7881
 | 07882 |  |  |  |  |  | 7882
 | 08160 |  |  |  |  |  | 8160
 | 008164 | 5 |  |  |  |  | 8164
 | 08164 |  |  |  |  |  | 8164
 | 08179 |  |  |  |  |  | 8179
 | 08615 |  |  |  |  |  | 8615
 | 008637 | 6 |  |  |  |  | 8637
 | 08637 |  |  |  |  |  | 8637
 | 08642 |  |  |  |  |  | 8642
 | 09208 |  |  |  |  |  | 9208
 | 009210 | 7 |  |  |  |  | 9210
 | 09210 |  |  |  |  |  | 9210
 | 09212 |  |  |  |  |  | 9212
 | 11573 |  |  |  |  |  | 11573
 | 011580 | 8 |  |  |  |  | 11580
 | 11580 |  |  |  |  |  | 11580
 | 11594 |  |  |  |  |  | 11594
 | 025152 |  |  |  |  |  | 25152
 | 025153 | 9 |  |  |  |  | 25153
 | 025153DoNotUse |  |  |  |  |  | 25153
 | 025154 |  |  |  |  |  | 25154
 | 025324 |  |  |  |  |  | 25324
 | 025325 | 10 |  |  |  |  | 25325
 | 25325 |  |  |  |  |  | 25325
 | 025326 |  |  |  |  |  | 25326
 | 025381 |  |  |  |  |  | 25381
 | 025382 | 11 |  |  |  |  | 25382
 | 25382 |  |  |  |  |  | 25382
 | 025383 |  |  |  |  |  | 25383
 | 025392 | 12 |  |  |  |  | 25392
 | 025392 x |  |  |  |  |  | 25392
 | 25392 |  |  |  |  |  | 25392
 | 025393 |  |  |  |  |  | 25393
 | 025394 | 13 |  |  |  |  | 25394
 | 25394 |  |  |  |  |  | 25394
 | 025395 |  |  |  |  |  | 25395
 | 025420 |  |  |  |  |  | 25420
 | 025421 | 14 |  |  |  |  | 25421
 | 25421 |  |  |  |  |  | 25421
 | 025422 | 15 |  |  |  |  | 25422
 | 25422 |  |  |  |  |  | 25422
 | 025423 |  |  |  |  |  | 25423
 | 025446 |  |  |  |  |  | 25446
 | 025447 | 16 |  |  |  |  | 25447
 | 25447 |  |  |  |  |  | 25447
 | 025448 |  |  |  |  |  | 25448
 | 025449 |  |  |  |  |  | 25449
 | 025450 | 17 |  |  |  |  | 25450
 | 25450 |  |  |  |  |  | 25450
 | 025451 |  |  |  |  |  | 25451
 | 025475 |  |  |  |  |  | 25475
 | 025476 | 18 |  |  |  |  | 25476
 | 25476 |  |  |  |  |  | 25476
 | 025477 |  |  |  |  |  | 25477
 | 025484 |  |  |  |  |  | 25484
 | 025485 | 19 |  |  |  |  | 25485
 | 25485 |  |  |  |  |  | 25485
 | 025486 |  |  |  |  |  | 25486
 | 025563 |  |  |  |  |  | 25563
 | 025564 | 20 |  |  |  |  | 25564
 | 25564 |  |  |  |  |  | 25564
 | 025565 |  |  |  |  |  | 25565
 | 025570 |  |  |  |  |  | 25570
 | 025571 | 21 |  |  |  |  | 25571
 | 25571 |  |  |  |  |  | 25571
 | 025577 |  |  |  |  |  | 25577
 | 025578 | 22 |  |  |  |  | 25578
 | 25578 |  |  |  |  |  | 25578
 | 025579 |  |  |  |  |  | 25579
 | 025592 |  |  |  |  |  | 25592
 | 025593 | 23 |  |  |  |  | 25593
 | 25593 |  |  |  |  |  | 25593
 | 025594 |  |  |  |  |  | 25594
 | 025597 |  |  |  |  |  | 25597
 | 025598 | 24 |  |  |  |  | 25598
 | 25598 |  |  |  |  |  | 25598
 | 025599 | 25 |  |  |  |  | 25599
 | 25599 |  |  |  |  |  | 25599
 | 025600 | 26 |  |  |  |  | 25600
 | 25600 |  |  |  |  |  | 25600
 | 025601 |  |  |  |  |  | 25601
 | 025603 |  |  |  |  |  | 25603
 | 025604 | 27 |  |  |  |  | 25604
 | 25604 |  |  |  |  |  | 25604
 | 025605 |  |  |  |  |  | 25605
 | 025606 | 28 |  |  |  |  | 25606
 | 25606 |  |  |  |  |  | 25606
 | 025607 |  |  |  |  |  | 25607
 | 025608 | 29 |  |  |  |  | 25608
 | 25608 |  |  |  |  |  | 25608
 | 025609 | 30 |  |  |  |  | 25609
 | 25609 |  |  |  |  |  | 25609
 | 025610 | 31 |  |  |  |  | 25610
 | 25610 |  |  |  |  |  | 25610
 | 025611 |  |  |  |  |  | 25611
 | 025615 |  |  |  |  |  | 25615
 | 025616 | 32 |  |  |  |  | 25616
 | 25616 |  |  |  |  |  | 25616
 | 025617 | 33 |  |  |  |  | 25617
 | 25617 |  |  |  |  |  | 25617
 | 025618 |  |  |  |  |  | 25618
 | 025640 |  |  |  |  |  | 25640
 | 025641 | 34 |  |  |  |  | 25641
 | 25641 |  |  |  |  |  | 25641
 | 025642 | 35 |  |  |  |  | 25642
 | 25642 |  |  |  |  |  | 25642
 | 025643 |  |  |  |  |  | 25643
 | 025652 |  |  |  |  |  | 25652
 | 025654 | 36 |  |  |  |  | 25654
 | 25654 |  |  |  |  |  | 25654
 | 025655 |  |  |  |  |  | 25655
 | 025656 | 37 |  |  |  |  | 25656
 | 25656 |  |  |  |  |  | 25656
 | 025657 |  |  |  |  |  | 25657
 | 025658 | 38 |  |  |  |  | 25658
 | 25658 |  |  |  |  |  | 25658
 | 025659 |  |  |  |  |  | 25659
 | 025936 | 39 |  |  |  |  | 25936
 | 025936 FAILED LINE 6 |  |  |  |  |  | 25936
 | 025937 |  |  |  |  |  | 25937
 | 025959 |  |  |  |  |  | 25959
 | 025960 | 40 |  |  |  |  | 25960
 | 25960 [NAME] Law’r [NAME] |  |  |  |  |  | 25960
 | 026408 |  |  |  |  |  | 26408
 | 026409 I'll Be Home For Christmas | 41 |  |  |  |  | 26409
 | 026409 SERIES |  |  |  |  |  | 26409
 | 026409SERIESAGAIN DON'T UPLOAD |  |  |  |  |  | 26409
 | 026410 |  |  |  |  |  | 26410
 | 026452 | 42 |  |  |  |  | 26452
 | 026452 WRONG NARRATOR |  |  |  |  |  | 26452
 | 400142 FIXED |  |  |  |  |  | 400142
 | 400155 Delia Smith's Complete Cookery Course to be fixed | 43 |  |  |  |  | 400155
 | 400155 original |  |  |  |  |  | 400155
 | 400235 |  |  |  |  |  | 400235
 | 400711 | 44 |  |  |  |  | 400711
 | 400711 original |  |  |  |  |  | 400711
 | 712652 |  |  |  |  |  | 712652
 | 712653 | 45 |  |  |  |  | 712653
 | 712653FAULTY |  |  |  |  |  | 712653
 | 713725 Spare | 46 |  |  |  |  | 713725
 | 713725x |  |  |  |  |  | 713725
 | 714211 |  |  |  |  |  | 714211
 | 807319 |  |  |  |  |  | 807319
 | 807320 | 47 |  |  |  |  | 807320
 | 807320 faulty original |  |  |  |  |  | 807320
 | 807321 |  |  |  |  |  | 807321