Spreadsheet: 150210d1334333274-excel-2007-calculating-number-of-unique-values-uniq
Sheet: 2011 - Sheet1

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