Spreadsheet: 150024d1334248913-excel-2007-calculating-number-of-unique-values-test_data
Sheet: 2011 - Sheet1

Business_Unit | subscrip_id | Business Unit & Subscrip ID | Value
ProductA | 1886827 |  | 0
ProductA | 1888595 |  | 0
ProductA | 1894421 |  | 0
ProductA | 1912968 |  | 0
ProductA | 1914430 |  | 0
ProductA | 1944045 |  | 0
ProductA | 1922246 |  | 0.0194982841139511
ProductA | 1881205 |  | 0
ProductA | 4153529 |  | 0.00649772579597141
ProductA | 1885481 |  | 0.006499428037983698
ProductA | 4202724 |  | 0
ProductA | 1869493 |  | 0.007768524369374031
ProductA | 2960818 |  | 0.01126775824685972
ProductA | 3864201 |  | -115.8718030611734
ProductA | 5843707 |  | 0
ProductA | 3330711 |  | 0.03512226111778492
ProductA | 1876813 |  | 0.03512226111778492
ProductA | 4930738 |  | 0.01756113055889246
ProductA | 3431410 |  | 0.03512226111778492
ProductA | 5991323 |  | -231.7176084101949
ProductA | 4005091 |  | 0.03512226111778492
ProductA | 5133963 |  | -153.342902527074
ProductA | 6002153 |  | -176.8054624669293
ProductA | 4282248 |  | 0.03512226111778492
ProductA | 1903250 |  | 10.21560954572685
ProductA | 5450390 |  | 0.03512226111778492
ProductA | 1852141 |  | 8.187134502923977
ProductA | 3630111 |  | 22.24995241811675
ProductA | 5540461 |  | 0.00878056527944623
ProductA | 6972977 |  | 22.24995241811675
ProductA | 6079580 |  | 0.03512226111778492
ProductA | 4574842 |  | 0.03512226111778492
ProductA | 1927868 |  | 16.37426900584795
ProductA | 3084299 |  | 0.01756113055889246
ProductA | 7660146 |  | 0.02634169583833869
ProductA | 3864201 |  | -128.7406705763811
ProductA | 1922076 |  | 22.06555818895466
ProductA | 1881523 |  | 36.50078786131645
ProductA | 1943367 |  | 40.88574375601553
ProductA | 4749847 |  | 32.74853801169591
ProductA | 4955480 |  | 43.38531513970111
ProductA | 1884352 |  | 42.82473134227459
ProductA | 1920430 |  | 0.03512226111778492
ProductA | 1922823 |  | 36.51378671739242
ProductA | 1888561 |  | 0
ProductA | 3328228 |  | 51.41047578045105
ProductA | 1914596 |  | 71.5558779663042
ProductA | 5286204 |  | 59.99622021862751
ProductA | 1872443 |  | -206.347544299313
ProductA | 1892401 |  | 0
ProductA | 5071330 |  | 205.9343773835135
ProductA | 1868853 |  | 94.22424601373748
ProductA | 5133963 |  | -153.342902527074
ProductA | 5991323 |  | -257.4553434406102
ProductA | 1917765 |  | 77.16770909498044
ProductA | 1882929 |  | 117.80884435433
ProductA | 1887262 |  | 85.7534535331569
ProductA | 5222371 |  | 85.7534535331569
ProductA | 5305471 |  | 0
ProductA | 5300266 |  | 142.148571308955
ProductA | 1870602 |  | 10.57456941779948
ProductA | 1867989 |  | 85.81844781353676
ProductA | 1915207 |  | 10.72124756335283
ProductA | 1867831 |  | 10.57456941779948
ProductA | 1892801 |  | 113.246034133828
ProductA | 7319878 |  | 10.57456941779948
ProductA | 1926721 |  | 14.55817723332185
ProductA | 1898566 |  | 14.55817723332185
ProductA | 3837521 |  | 10.17543859649123
ProductA | 1922122 |  | 10.57456941779948
ProductA | 4567455 |  | 19.2578052765457
ProductA | 4581075 |  | 0.02599090318388564
ProductA | 1889541 |  | 79.31901977555306
ProductA | 1878778 |  | 21.44249512670565
ProductA | 7003633 |  | 29.09001277080536
ProductA | 7029586 |  | 29.09001277080536
ProductA | 1922840 |  | 29.09001277080536
ProductA | 7186193 |  | 154.9945383127848
ProductA | 6925383 |  | 0.02634169583833869
ProductA | 5689457 |  | 40.1079704223974
ProductA | 1884107 |  | 31.8147002459302
ProductA | 7040610 |  | 31.14408379432026
ProductA | 4581377 |  | 31.14408379432026
ProductA | 1907727 |  | 113.246034133828
ProductA | 3217655 |  | 58.15368384577238
ProductA | 1851756 |  | 31.1328160360734
ProductA | 3195091 |  | 46.65978690024609
ProductA | 9062432 |  | 28.34400567364691
ProductA | 9064567 |  | 30.07935295978855
ProductA | 3980014 |  | 72.6855193832559
ProductA | 3958418 |  | 53.05483107406093
ProductA | 1910183 |  | 53.05483107406093
ProductA | 3938387 |  | 53.60623781676414
ProductA | 7184581 |  | 72.6855193832559
ProductA | 1914103 |  | 72.6855193832559
ProductA | 3276228 |  | 93.2068962180236
ProductA | 1886941 |  | 154.9945383127848
ProductA | 1886932 |  | 150.3583998452372
ProductA | 1883950 |  | 63.6748964881263
ProductA | 1873849 |  | 63.6748964881263
ProductA | 5734428 |  | 113.246034133828
ProductA | 7184778 |  | 87.21735492073942
ProductA | 1886118 |  | 63.6748964881263
ProductA | 1912828 |  | 63.6748964881263
ProductA | 1886185 |  | 63.6748964881263
ProductA | 9130136 |  | 114.3859649122807
ProductA | 7040547 |  | 62.16422224792507
ProductA | 1878603 |  | 58.12734214993405
ProductA | 2997886 |  | 101.7491904582229
ProductA | 1888595 |  | 101.7491904582229
ProductA | 2943042 |  | 101.7491904582229
ProductA | 1889036 |  | 75.04873294346979
ProductA | 1888820 |  | 74.29496190219166
ProductA | 1871951 |  | 74.29496190219166
ProductA | 1882503 |  | 74.29496190219166
ProductA | 1881817 |  | 75.04873294346979
ProductA | 1899317 |  | 88.4912610915396
ProductA | 1877232 |  | 88.4912610915396
ProductA | 1878450 |  | 154.9945383127848
ProductA | 1925989 |  | 53.60623781676414
ProductA | 2960818 |  | 108.7225993239494
ProductA | 1863347 |  | 108.7225993239494
ProductB | 4585208 |  | 277.2579597141001
ProductB | 8659648 |  | 344.8667966211825
ProductB | 9888381 |  | 277.2579597141001
ProductB | 1874039 |  | 89.66882012850964
ProductB | 1857398 |  | 89.66882012850964
ProductB | 3843441 |  | 403.5096905782934
ProductB | 3878040 |  | 0
ProductB | 5574471 |  | 278.6694765565891
ProductB | 9118420 |  | 0
ProductB | 6978851 |  | 0
ProductB | 1865153 |  | 62.7030539311241
ProductB | 1865765 |  | 391.8854089869647
ProductB | 5646855 |  | 391.8854089869647
ProductB | 8103372 |  | 344.8667966211825
ProductB | 1901320 |  | 443.8595328602981
ProductB | 3645088 |  | 313.5152696556205
ProductB | 1907531 |  | 219.4606887589343
ProductB | 9898981 |  | 928.9047546166682
ProductB | 1888081 |  | 313.5152696556205
ProductB | 1886461 |  | 198.154562022047
ProductB | 5484928 |  | 340.5960269024978
ProductB | 9483977 |  | 310.4093567251462
ProductB | 1923382 |  | 442.1717063423534
ProductB | 7717881 |  | 435.4282322077386
ProductB | 1883577 |  | 313.5013027373482
ProductB | 7000944 |  | 348.3425857661908
ProductB | 5647312 |  | 348.3425857661908
ProductB | 9552863 |  | 348.3513663314703
ProductB | 1880004 |  | 286.9221959980359
ProductB | 3624064 |  | 391.8854089869647
ProductC | 7938683 |  | 325.6382133342459
ProductC | 9630422 |  | 217.5373619233268
ProductC | 8663050 |  | 224.9447693307342
ProductC | 9639225 |  | 215.7829759584145
ProductC | 9639233 |  | 215.7829759584145
ProductC | 8010439 |  | 252.4366471734892
ProductC | 9658114 |  | 247.1604938271605
ProductC | 7947038 |  | 267.2109849256238
ProductC | 9744428 |  | 389.6954189676434
ProductC | 9744461 |  | 270.3053931124106
ProductC | 9748105 |  | 123.8937760929863
ProductC | 9748156 |  | 123.8937760929863
ProductC | 9749055 |  | 273.6844152514556
ProductC | 9750657 |  | 123.8937760929863
ProductC | 9750681 |  | 143.0266278368996
ProductC | 9248200 |  | 387.6619570875511
ProductC | 9752188 |  | 123.8937760929863
ProductC | 9753109 |  | 123.8937760929863
ProductC | 9755659 |  | 123.8937760929863
ProductC | 9755705 |  | 303.7312710710542
ProductC | 9755811 |  | 280.1578455772873
ProductC | 9759701 |  | 284.7789389122938
ProductC | 9759786 |  | 284.7789389122938
ProductC | 9760954 |  | 123.8937760929863
ProductC | 9760962 |  | 123.8937760929863
ProductC | 9764151 |  | 123.8937760929863
ProductC | 9764411 |  | 322.6901026578527
ProductC | 9752919 |  | 414.8904900191138
ProductC | 7791496 |  | 414.8904900191138
ProductC | 9771271 |  | 123.8937760929863
ProductC | 9771581 |  | 414.8904900191138
ProductC | 9771603 |  | 123.8937760929863
ProductC | 9757074 |  | 339.1668950491696
ProductC | 9752242 |  | 1.589282315579768
ProductC | 9796614 |  | 457.7414110204293
ProductC | 9796622 |  | 457.7414110204293
ProductC | 9181580 |  | 321.767183876459
ProductC | 9802720 |  | 323.6130214392463
ProductC | 9805532 |  | 328.2341147742528
ProductC | 9805559 |  | 321.760684448421
ProductC | 9809775 |  | 370.285218399527
ProductC | 9408193 |  | 466.7485085595232
ProductC | 9752242 |  | 47.81895851186417
ProductC | 9752242 |  | 47.81895851186417
ProductC | 9826025 |  | 320.8377656670273
ProductC | 9752242 |  | 47.81895851186417
ProductC | 9831533 |  | 319.6881091617933
ProductC | 9838775 |  | 668.8171428206747
ProductC | 9843922 |  | 134.5144979510113
ProductC | 9854380 |  | 194.3989603638726
ProductC | 9854398 |  | 371.0491275788388
ProductC | 9752242 |  | 47.81895851186417
ProductC | 9857834 |  | 413.0816935715479
ProductC | 9868976 |  | 377.2921094925251
ProductC | 9870733 |  | 411.0252853289489
ProductC | 9874135 |  | 184.2170240415854
ProductC | 9875140 |  | 33.83602236574313
ProductC | 9875140 |  | 33.82952293770515
ProductC | 9875140 |  | 33.82952293770515
ProductC | 9878491 |  | 255.193542483392
ProductC | 9880470 |  | 0
ProductC | 9880542 |  | 390.2522238449877