Make a table from data which updated monthly.

adnan1975

New Member
Joined
Aug 24, 2017
Messages
38
Hello,

I'm currently working on creating a table in Sheet2 using data from Sheet1, and I intend to accomplish this using a VBA Macro. I prefer not to use a pivot table for this task. I've already prepared a sample table in Sheet2. This table will incorporate data from the "Unit Sold" column in Sheet1. However, my objective is to count the total number of units sold for each country.

I would greatly appreciate any help.

Sheet1 data below


SegmentCountryProductDiscount BandUnits SoldManufacturing PriceSale PriceGross SalesDiscountsSalesCOGSProfitDateMonth NumberMonth NameYear
GovernmentCanadaCarreteraNone
1618.5​
$ 3.00$ 20.00$ 32,370.00$ -$ 32,370.00$ 16,185.00$ 16,185.00
1/1/2014​
1​
January2014
GovernmentGermanyCarreteraNone
1321​
$ 3.00$ 20.00$ 26,420.00$ -$ 26,420.00$ 13,210.00$ 13,210.00
1/1/2014​
1​
January2014
MidmarketFranceCarreteraNone
2178​
$ 3.00$ 15.00$ 32,670.00$ -$ 32,670.00$ 21,780.00$ 10,890.00
6/1/2014​
6​
June2014
MidmarketGermanyCarreteraNone
888​
$ 3.00$ 15.00$ 13,320.00$ -$ 13,320.00$ 8,880.00$ 4,440.00
6/1/2014​
6​
June2014
MidmarketMexicoCarreteraNone
2470​
$ 3.00$ 15.00$ 37,050.00$ -$ 37,050.00$ 24,700.00$ 12,350.00
6/1/2014​
6​
June2014
GovernmentGermanyCarreteraNone
1513​
$ 3.00$ 350.00$ 529,550.00$ -$ 529,550.00$ 393,380.00$ 136,170.00
12/1/2014​
12​
December2014
MidmarketGermanyMontanaNone
921​
$ 5.00$ 15.00$ 13,815.00$ -$ 13,815.00$ 9,210.00$ 4,605.00
3/1/2014​
3​
March2014
Channel PartnersCanadaMontanaNone
2518​
$ 5.00$ 12.00$ 30,216.00$ -$ 30,216.00$ 7,554.00$ 22,662.00
6/1/2014​
6​
June2014
GovernmentFranceMontanaNone
1899​
$ 5.00$ 20.00$ 37,980.00$ -$ 37,980.00$ 18,990.00$ 18,990.00
6/1/2014​
6​
June2014
Channel PartnersGermanyMontanaNone
1545​
$ 5.00$ 12.00$ 18,540.00$ -$ 18,540.00$ 4,635.00$ 13,905.00
6/1/2014​
6​
June2014
MidmarketMexicoMontanaNone
2470​
$ 5.00$ 15.00$ 37,050.00$ -$ 37,050.00$ 24,700.00$ 12,350.00
6/1/2014​
6​
June2014
EnterpriseCanadaMontanaNone
2665.5​
$ 5.00$ 125.00$ 333,187.50$ -$ 333,187.50$ 319,860.00$ 13,327.50
7/1/2014​
7​
July2014
Small BusinessMexicoMontanaNone
958​
$ 5.00$ 300.00$ 287,400.00$ -$ 287,400.00$ 239,500.00$ 47,900.00
8/1/2014​
8​
August2014
GovernmentGermanyMontanaNone
2146​
$ 5.00$ 7.00$ 15,022.00$ -$ 15,022.00$ 10,730.00$ 4,292.00
9/1/2014​
9​
September2014
EnterpriseCanadaMontanaNone
345​
$ 5.00$ 125.00$ 43,125.00$ -$ 43,125.00$ 41,400.00$ 1,725.00
10/1/2013​
10​
October2013
MidmarketUnited States of AmericaMontanaNone
615​
$ 5.00$ 15.00$ 9,225.00$ -$ 9,225.00$ 6,150.00$ 3,075.00
12/1/2014​
12​
December2014
GovernmentCanadaPaseoNone
292​
$ 10.00$ 20.00$ 5,840.00$ -$ 5,840.00$ 2,920.00$ 2,920.00
2/1/2014​
2​
February2014
MidmarketMexicoPaseoNone
974​
$ 10.00$ 15.00$ 14,610.00$ -$ 14,610.00$ 9,740.00$ 4,870.00
2/1/2014​
2​
February2014
Channel PartnersCanadaPaseoNone
2518​
$ 10.00$ 12.00$ 30,216.00$ -$ 30,216.00$ 7,554.00$ 22,662.00
6/1/2014​
6​
June2014
GovernmentGermanyPaseoNone
1006​
$ 10.00$ 350.00$ 352,100.00$ -$ 352,100.00$ 261,560.00$ 90,540.00
6/1/2014​
6​
June2014
Channel PartnersGermanyPaseoNone
367​
$ 10.00$ 12.00$ 4,404.00$ -$ 4,404.00$ 1,101.00$ 3,303.00
7/1/2014​
7​
July2014
GovernmentMexicoPaseoNone
883​
$ 10.00$ 7.00$ 6,181.00$ -$ 6,181.00$ 4,415.00$ 1,766.00
8/1/2014​
8​
August2014
MidmarketFrancePaseoNone
549​
$ 10.00$ 15.00$ 8,235.00$ -$ 8,235.00$ 5,490.00$ 2,745.00
9/1/2013​
9​
September2013
Small BusinessMexicoPaseoNone
788​
$ 10.00$ 300.00$ 236,400.00$ -$ 236,400.00$ 197,000.00$ 39,400.00
9/1/2013​
9​
September2013
MidmarketMexicoPaseoNone
2472​
$ 10.00$ 15.00$ 37,080.00$ -$ 37,080.00$ 24,720.00$ 12,360.00
9/1/2014​
9​
September2014
GovernmentUnited States of AmericaPaseoNone
1143​
$ 10.00$ 7.00$ 8,001.00$ -$ 8,001.00$ 5,715.00$ 2,286.00
10/1/2014​
10​
October2014
GovernmentCanadaPaseoNone
1725​
$ 10.00$ 350.00$ 603,750.00$ -$ 603,750.00$ 448,500.00$ 155,250.00
11/1/2013​
11​
November2013
Channel PartnersUnited States of AmericaPaseoNone
912​
$ 10.00$ 12.00$ 10,944.00$ -$ 10,944.00$ 2,736.00$ 8,208.00
11/1/2013​
11​
November2013
MidmarketCanadaPaseoNone
2152​
$ 10.00$ 15.00$ 32,280.00$ -$ 32,280.00$ 21,520.00$ 10,760.00
12/1/2013​
12​
December2013
GovernmentCanadaPaseoNone
1817​
$ 10.00$ 20.00$ 36,340.00$ -$ 36,340.00$ 18,170.00$ 18,170.00
12/1/2014​
12​
December2014
GovernmentGermanyPaseoNone
1513​
$ 10.00$ 350.00$ 529,550.00$ -$ 529,550.00$ 393,380.00$ 136,170.00
12/1/2014​
12​
December2014
GovernmentMexicoVeloNone
1493​
$ 120.00$ 7.00$ 10,451.00$ -$ 10,451.00$ 7,465.00$ 2,986.00
1/1/2014​
1​
January2014
EnterpriseFranceVeloNone
1804​
$ 120.00$ 125.00$ 225,500.00$ -$ 225,500.00$ 216,480.00$ 9,020.00
2/1/2014​
2​
February2014
Channel PartnersGermanyVeloNone
2161​
$ 120.00$ 12.00$ 25,932.00$ -$ 25,932.00$ 6,483.00$ 19,449.00
3/1/2014​
3​
March2014
GovernmentGermanyVeloNone
1006​
$ 120.00$ 350.00$ 352,100.00$ -$ 352,100.00$ 261,560.00$ 90,540.00
6/1/2014​
6​
June2014
Channel PartnersGermanyVeloNone
1545​
$ 120.00$ 12.00$ 18,540.00$ -$ 18,540.00$ 4,635.00$ 13,905.00
6/1/2014​
6​
June2014
EnterpriseUnited States of AmericaVeloNone
2821​
$ 120.00$ 125.00$ 352,625.00$ -$ 352,625.00$ 338,520.00$ 14,105.00
8/1/2014​
8​
August2014
EnterpriseCanadaVeloNone
345​
$ 120.00$ 125.00$ 43,125.00$ -$ 43,125.00$ 41,400.00$ 1,725.00
10/1/2013​
10​
October2013
Small BusinessCanadaVTTNone
2001​
$ 250.00$ 300.00$ 600,300.00$ -$ 600,300.00$ 500,250.00$ 100,050.00
2/1/2014​
2​
February2014
Channel PartnersGermanyVTTNone
2838​
$ 250.00$ 12.00$ 34,056.00$ -$ 34,056.00$ 8,514.00$ 25,542.00
4/1/2014​
4​
April2014
MidmarketFranceVTTNone
2178​
$ 250.00$ 15.00$ 32,670.00$ -$ 32,670.00$ 21,780.00$ 10,890.00
6/1/2014​
6​
June2014
MidmarketGermanyVTTNone
888​
$ 250.00$ 15.00$ 13,320.00$ -$ 13,320.00$ 8,880.00$ 4,440.00
6/1/2014​
6​
June2014
GovernmentFranceVTTNone
1527​
$ 250.00$ 350.00$ 534,450.00$ -$ 534,450.00$ 397,020.00$ 137,430.00
9/1/2013​
9​
September2013
Small BusinessFranceVTTNone
2151​
$ 250.00$ 300.00$ 645,300.00$ -$ 645,300.00$ 537,750.00$ 107,550.00
9/1/2014​
9​
September2014
GovernmentCanadaVTTNone
1817​
$ 250.00$ 20.00$ 36,340.00$ -$ 36,340.00$ 18,170.00$ 18,170.00
12/1/2014​
12​
December2014
GovernmentFranceAmarillaNone
2750​
$ 260.00$ 350.00$ 962,500.00$ -$ 962,500.00$ 715,000.00$ 247,500.00
2/1/2014​
2​
February2014
Channel PartnersUnited States of AmericaAmarillaNone
1953​
$ 260.00$ 12.00$ 23,436.00$ -$ 23,436.00$ 5,859.00$ 17,577.00
4/1/2014​
4​
April2014
EnterpriseGermanyAmarillaNone
4219.5​
$ 260.00$ 125.00$ 527,437.50$ -$ 527,437.50$ 506,340.00$ 21,097.50
4/1/2014​
4​
April2014
GovernmentFranceAmarillaNone
1899​
$ 260.00$ 20.00$ 37,980.00$ -$ 37,980.00$ 18,990.00$ 18,990.00
6/1/2014​
6​
June2014
GovernmentGermanyAmarillaNone
1686​
$ 260.00$ 7.00$ 11,802.00$ -$ 11,802.00$ 8,430.00$ 3,372.00
7/1/2014​
7​
July2014
Channel PartnersUnited States of AmericaAmarillaNone
2141​
$ 260.00$ 12.00$ 25,692.00$ -$ 25,692.00$ 6,423.00$ 19,269.00
8/1/2014​
8​
August2014
GovernmentUnited States of AmericaAmarillaNone
1143​
$ 260.00$ 7.00$ 8,001.00$ -$ 8,001.00$ 5,715.00$ 2,286.00
10/1/2014​
10​
October2014
MidmarketUnited States of AmericaAmarillaNone
615​
$ 260.00$ 15.00$ 9,225.00$ -$ 9,225.00$ 6,150.00$ 3,075.00
12/1/2014​
12​
December2014
GovernmentFrancePaseoLow
3945​
$ 10.00$ 7.00$ 27,615.00$ 276.15$ 27,338.85$ 19,725.00$ 7,613.85
1/1/2014​
1​
January2014
MidmarketFrancePaseoLow
2296​
$ 10.00$ 15.00$ 34,440.00$ 344.40$ 34,095.60$ 22,960.00$ 11,135.60
2/1/2014​
2​
February2014
GovernmentFrancePaseoLow
1030​
$ 10.00$ 7.00$ 7,210.00$ 72.10$ 7,137.90$ 5,150.00$ 1,987.90
5/1/2014​
5​
May2014
GovernmentFranceVeloLow
639​
$ 120.00$ 7.00$ 4,473.00$ 44.73$ 4,428.27$ 3,195.00$ 1,233.27
11/1/2014​
11​
November2014
GovernmentCanadaVTTLow
1326​
$ 250.00$ 7.00$ 9,282.00$ 92.82$ 9,189.18$ 6,630.00$ 2,559.18
3/1/2014​
3​
March2014
Channel PartnersUnited States of AmericaCarreteraLow
1858​
$ 3.00$ 12.00$ 22,296.00$ 222.96$ 22,073.04$ 5,574.00$ 16,499.04
2/1/2014​
2​
February2014
GovernmentMexicoCarreteraLow
1210​
$ 3.00$ 350.00$ 423,500.00$ 4,235.00$ 419,265.00$ 314,600.00$ 104,665.00
3/1/2014​
3​
March2014
GovernmentUnited States of AmericaCarreteraLow
2529​
$ 3.00$ 7.00$ 17,703.00$ 177.03$ 17,525.97$ 12,645.00$ 4,880.97
7/1/2014​
7​
July2014
Channel PartnersCanadaCarreteraLow
1445​
$ 3.00$ 12.00$ 17,340.00$ 173.40$ 17,166.60$ 4,335.00$ 12,831.60
9/1/2014​
9​
September2014
EnterpriseUnited States of AmericaCarreteraLow
330​
$ 3.00$ 125.00$ 41,250.00$ 412.50$ 40,837.50$ 39,600.00$ 1,237.50
9/1/2013​
9​
September2013
Channel PartnersFranceCarreteraLow
2671​
$ 3.00$ 12.00$ 32,052.00$ 320.52$ 31,731.48$ 8,013.00$ 23,718.48
9/1/2014​
9​
September2014
Channel PartnersGermanyCarreteraLow
766​
$ 3.00$ 12.00$ 9,192.00$ 91.92$ 9,100.08$ 2,298.00$ 6,802.08
10/1/2013​
10​
October2013
Small BusinessMexicoCarreteraLow
494​
$ 3.00$ 300.00$ 148,200.00$ 1,482.00$ 146,718.00$ 123,500.00$ 23,218.00
10/1/2013​
10​
October2013
GovernmentMexicoCarreteraLow
1397​
$ 3.00$ 350.00$ 488,950.00$ 4,889.50$ 484,060.50$ 363,220.00$ 120,840.50
10/1/2014​
10​
October2014
GovernmentFranceCarreteraLow
2155​
$ 3.00$ 350.00$ 754,250.00$ 7,542.50$ 746,707.50$ 560,300.00$ 186,407.50
12/1/2014​
12​
December2014
MidmarketMexicoMontanaLow
2214​
$ 5.00$ 15.00$ 33,210.00$ 332.10$ 32,877.90$ 22,140.00$ 10,737.90
3/1/2014​
3​
March2014
Small BusinessUnited States of AmericaMontanaLow
2301​
$ 5.00$ 300.00$ 690,300.00$ 6,903.00$ 683,397.00$ 575,250.00$ 108,147.00
4/1/2014​
4​
April2014
GovernmentFranceMontanaLow
1375.5​
$ 5.00$ 20.00$ 27,510.00$ 275.10$ 27,234.90$ 13,755.00$ 13,479.90
7/1/2014​
7​
July2014
GovernmentCanadaMontanaLow
1830​
$ 5.00$ 7.00$ 12,810.00$ 128.10$ 12,681.90$ 9,150.00$ 3,531.90
8/1/2014​
8​
August2014
Small BusinessUnited States of AmericaMontanaLow
2498​
$ 5.00$ 300.00$ 749,400.00$ 7,494.00$ 741,906.00$ 624,500.00$ 117,406.00
9/1/2013​
9​
September2013
EnterpriseUnited States of AmericaMontanaLow
663​
$ 5.00$ 125.00$ 82,875.00$ 828.75$ 82,046.25$ 79,560.00$ 2,486.25
10/1/2013​
10​
October2013
MidmarketUnited States of AmericaPaseoLow
1514​
$ 10.00$ 15.00$ 22,710.00$ 227.10$ 22,482.90$ 15,140.00$ 7,342.90
2/1/2014​
2​
February2014
GovernmentUnited States of AmericaPaseoLow
4492.5​
$ 10.00$ 7.00$ 31,447.50$ 314.48$ 31,133.03$ 22,462.50$ 8,670.53
4/1/2014​
4​
April2014
EnterpriseUnited States of AmericaPaseoLow
727​
$ 10.00$ 125.00$ 90,875.00$ 908.75$ 89,966.25$ 87,240.00$ 2,726.25
6/1/2014​
6​
June2014
EnterpriseFrancePaseoLow
787​
$ 10.00$ 125.00$ 98,375.00$ 983.75$ 97,391.25$ 94,440.00$ 2,951.25
6/1/2014​
6​
June2014
EnterpriseMexicoPaseoLow
1823​
$ 10.00$ 125.00$ 227,875.00$ 2,278.75$ 225,596.25$ 218,760.00$ 6,836.25
7/1/2014​
7​
July2014
MidmarketGermanyPaseoLow
747​
$ 10.00$ 15.00$ 11,205.00$ 112.05$ 11,092.95$ 7,470.00$ 3,622.95
9/1/2014​
9​
September2014
Channel PartnersGermanyPaseoLow
766​
$ 10.00$ 12.00$ 9,192.00$ 91.92$ 9,100.08$ 2,298.00$ 6,802.08
10/1/2013​
10​
October2013
Small BusinessUnited States of AmericaPaseoLow
2905​
$ 10.00$ 300.00$ 871,500.00$ 8,715.00$ 862,785.00$ 726,250.00$ 136,535.00
11/1/2014​
11​
November2014
GovernmentFrancePaseoLow
2155​
$ 10.00$ 350.00$ 754,250.00$ 7,542.50$ 746,707.50$ 560,300.00$ 186,407.50
12/1/2014​
12​
December2014
GovernmentFranceVeloLow
3864​
$ 120.00$ 20.00$ 77,280.00$ 772.80$ 76,507.20$ 38,640.00$ 37,867.20
4/1/2014​
4​
April2014
GovernmentMexicoVeloLow
362​
$ 120.00$ 7.00$ 2,534.00$ 25.34$ 2,508.66$ 1,810.00$ 698.66
5/1/2014​
5​
May2014
EnterpriseCanadaVeloLow
923​
$ 120.00$ 125.00$ 115,375.00$ 1,153.75$ 114,221.25$ 110,760.00$ 3,461.25
8/1/2014​
8​
August2014
EnterpriseUnited States of AmericaVeloLow
663​
$ 120.00$ 125.00$ 82,875.00$ 828.75$ 82,046.25$ 79,560.00$ 2,486.25
10/1/2013​
10​
October2013
GovernmentCanadaVeloLow
2092​
$ 120.00$ 7.00$ 14,644.00$ 146.44$ 14,497.56$ 10,460.00$ 4,037.56
11/1/2013​
11​
November2013
GovernmentGermanyVTTLow
263​
$ 250.00$ 7.00$ 1,841.00$ 18.41$ 1,822.59$ 1,315.00$ 507.59
3/1/2014​
3​
March2014
GovernmentCanadaVTTLow
943.5​
$ 250.00$ 350.00$ 330,225.00$ 3,302.25$ 326,922.75$ 245,310.00$ 81,612.75
4/1/2014​
4​
April2014
EnterpriseUnited States of AmericaVTTLow
727​
$ 250.00$ 125.00$ 90,875.00$ 908.75$ 89,966.25$ 87,240.00$ 2,726.25
6/1/2014​
6​
June2014
EnterpriseFranceVTTLow
787​
$ 250.00$ 125.00$ 98,375.00$ 983.75$ 97,391.25$ 94,440.00$ 2,951.25
6/1/2014​
6​
June2014
Small BusinessGermanyVTTLow
986​
$ 250.00$ 300.00$ 295,800.00$ 2,958.00$ 292,842.00$ 246,500.00$ 46,342.00
9/1/2014​
9​
September2014
Small BusinessMexicoVTTLow
494​
$ 250.00$ 300.00$ 148,200.00$ 1,482.00$ 146,718.00$ 123,500.00$ 23,218.00
10/1/2013​
10​
October2013
GovernmentMexicoVTTLow
1397​
$ 250.00$ 350.00$ 488,950.00$ 4,889.50$ 484,060.50$ 363,220.00$ 120,840.50
10/1/2014​
10​
October2014
EnterpriseFranceVTTLow
1744​
$ 250.00$ 125.00$ 218,000.00$ 2,180.00$ 215,820.00$ 209,280.00$ 6,540.00
11/1/2014​
11​
November2014
Channel PartnersUnited States of AmericaAmarillaLow
1989​
$ 260.00$ 12.00$ 23,868.00$ 238.68$ 23,629.32$ 5,967.00$ 17,662.32
9/1/2013​
9​
September2013
MidmarketFranceAmarillaLow
321​
$ 260.00$ 15.00$ 4,815.00$ 48.15$ 4,766.85$ 3,210.00$ 1,556.85
11/1/2013​
11​
November2013
EnterpriseCanadaCarreteraLow
742.5​
$ 3.00$ 125.00$ 92,812.50$ 1,856.25$ 90,956.25$ 89,100.00$ 1,856.25
4/1/2014​
4​
April2014
Channel PartnersCanadaCarreteraLow
1295​
$ 3.00$ 12.00$ 15,540.00$ 310.80$ 15,229.20$ 3,885.00$ 11,344.20
10/1/2014​
10​
October2014
Small BusinessGermanyCarreteraLow
214​
$ 3.00$ 300.00$ 64,200.00$ 1,284.00$ 62,916.00$ 53,500.00$ 9,416.00
10/1/2013​
10​
October2013
GovernmentFranceCarreteraLow
2145​
$ 3.00$ 7.00$ 15,015.00$ 300.30$ 14,714.70$ 10,725.00$ 3,989.70
11/1/2013​
11​
November2013
GovernmentCanadaCarreteraLow
2852​
$ 3.00$ 350.00$ 998,200.00$ 19,964.00$ 978,236.00$ 741,520.00$ 236,716.00
12/1/2014​
12​
December2014
Channel PartnersUnited States of AmericaMontanaLow
1142​
$ 5.00$ 12.00$ 13,704.00$ 274.08$ 13,429.92$ 3,426.00$ 10,003.92
6/1/2014​
6​
June2014
GovernmentUnited States of AmericaMontanaLow
1566​
$ 5.00$ 20.00$ 31,320.00$ 626.40$ 30,693.60$ 15,660.00$ 15,033.60
10/1/2014​
10​
October2014
Channel PartnersMexicoMontanaLow
690​
$ 5.00$ 12.00$ 8,280.00$ 165.60$ 8,114.40$ 2,070.00$ 6,044.40
11/1/2014​
11​
November2014
EnterpriseMexicoMontanaLow
1660​
$ 5.00$ 125.00$ 207,500.00$ 4,150.00$ 203,350.00$ 199,200.00$ 4,150.00
11/1/2013​
11​
November2013
MidmarketCanadaPaseoLow
2363​
$ 10.00$ 15.00$ 35,445.00$ 708.90$ 34,736.10$ 23,630.00$ 11,106.10
2/1/2014​
2​
February2014
Small BusinessFrancePaseoLow
918​
$ 10.00$ 300.00$ 275,400.00$ 5,508.00$ 269,892.00$ 229,500.00$ 40,392.00
5/1/2014​
5​
May2014
Small BusinessGermanyPaseoLow
1728​
$ 10.00$ 300.00$ 518,400.00$ 10,368.00$ 508,032.00$ 432,000.00$ 76,032.00
5/1/2014​
5​
May2014
Channel PartnersUnited States of AmericaPaseoLow
1142​
$ 10.00$ 12.00$ 13,704.00$ 274.08$ 13,429.92$ 3,426.00$ 10,003.92
6/1/2014​
6​
June2014
EnterpriseMexicoPaseoLow
662​
$ 10.00$ 125.00$ 82,750.00$ 1,655.00$ 81,095.00$ 79,440.00$ 1,655.00
6/1/2014​
6​
June2014
Channel PartnersCanadaPaseoLow
1295​
$ 10.00$ 12.00$ 15,540.00$ 310.80$ 15,229.20$ 3,885.00$ 11,344.20
10/1/2014​
10​
October2014
EnterpriseGermanyPaseoLow
809​
$ 10.00$ 125.00$ 101,125.00$ 2,022.50$ 99,102.50$ 97,080.00$ 2,022.50
10/1/2013​
10​
October2013
EnterpriseMexicoPaseoLow
2145​
$ 10.00$ 125.00$ 268,125.00$ 5,362.50$ 262,762.50$ 257,400.00$ 5,362.50
10/1/2013​
10​
October2013
Channel PartnersFrancePaseoLow
1785​
$ 10.00$ 12.00$ 21,420.00$ 428.40$ 20,991.60$ 5,355.00$ 15,636.60
11/1/2013​
11​
November2013
Small BusinessCanadaPaseoLow
1916​
$ 10.00$ 300.00$ 574,800.00$ 11,496.00$ 563,304.00$ 479,000.00$ 84,304.00
12/1/2014​
12​
December2014
GovernmentCanadaPaseoLow
2852​
$ 10.00$ 350.00$ 998,200.00$ 19,964.00$ 978,236.00$ 741,520.00$ 236,716.00
12/1/2014​
12​
December2014
EnterpriseCanadaPaseoLow
2729​
$ 10.00$ 125.00$ 341,125.00$ 6,822.50$ 334,302.50$ 327,480.00$ 6,822.50
12/1/2014​
12​
December2014
MidmarketUnited States of AmericaPaseoLow
1925​
$ 10.00$ 15.00$ 28,875.00$ 577.50$ 28,297.50$ 19,250.00$ 9,047.50
12/1/2013​
12​
December2013
GovernmentUnited States of AmericaPaseoLow
2013​
$ 10.00$ 7.00$ 14,091.00$ 281.82$ 13,809.18$ 10,065.00$ 3,744.18
12/1/2013​
12​
December2013
Channel PartnersFrancePaseoLow
1055​
$ 10.00$ 12.00$ 12,660.00$ 253.20$ 12,406.80$ 3,165.00$ 9,241.80
12/1/2014​
12​
December2014
Channel PartnersMexicoPaseoLow
1084​
$ 10.00$ 12.00$ 13,008.00$ 260.16$ 12,747.84$ 3,252.00$ 9,495.84
12/1/2014​
12​
December2014
GovernmentUnited States of AmericaVeloLow
1566​
$ 120.00$ 20.00$ 31,320.00$ 626.40$ 30,693.60$ 15,660.00$ 15,033.60
10/1/2014​
10​
October2014
GovernmentGermanyVeloLow
2966​
$ 120.00$ 350.00$ 1,038,100.00$ 20,762.00$ 1,017,338.00$ 771,160.00$ 246,178.00
10/1/2013​
10​
October2013
GovernmentGermanyVeloLow
2877​
$ 120.00$ 350.00$ 1,006,950.00$ 20,139.00$ 986,811.00$ 748,020.00$ 238,791.00
10/1/2014​
10​
October2014
EnterpriseGermanyVeloLow
809​
$ 120.00$ 125.00$ 101,125.00$ 2,022.50$ 99,102.50$ 97,080.00$ 2,022.50
10/1/2013​
10​
October2013
EnterpriseMexicoVeloLow
2145​
$ 120.00$ 125.00$ 268,125.00$ 5,362.50$ 262,762.50$ 257,400.00$ 5,362.50
10/1/2013​
10​
October2013
Channel PartnersFranceVeloLow
1055​
$ 120.00$ 12.00$ 12,660.00$ 253.20$ 12,406.80$ 3,165.00$ 9,241.80
12/1/2014​
12​
December2014
GovernmentMexicoVeloLow
544​
$ 120.00$ 20.00$ 10,880.00$ 217.60$ 10,662.40$ 5,440.00$ 5,222.40
12/1/2013​
12​
December2013
Channel PartnersMexicoVeloLow
1084​
$ 120.00$ 12.00$ 13,008.00$ 260.16$ 12,747.84$ 3,252.00$ 9,495.84
12/1/2014​
12​
December2014
EnterpriseMexicoVTTLow
662​
$ 250.00$ 125.00$ 82,750.00$ 1,655.00$ 81,095.00$ 79,440.00$ 1,655.00
6/1/2014​
6​
June2014
Small BusinessGermanyVTTLow
214​
$ 250.00$ 300.00$ 64,200.00$ 1,284.00$ 62,916.00$ 53,500.00$ 9,416.00
10/1/2013​
10​
October2013
GovernmentGermanyVTTLow
2877​
$ 250.00$ 350.00$ 1,006,950.00$ 20,139.00$ 986,811.00$ 748,020.00$ 238,791.00
10/1/2014​
10​
October2014
EnterpriseCanadaVTTLow
2729​
$ 250.00$ 125.00$ 341,125.00$ 6,822.50$ 334,302.50$ 327,480.00$ 6,822.50
12/1/2014​
12​
December2014
GovernmentUnited States of AmericaVTTLow
266​
$ 250.00$ 350.00$ 93,100.00$ 1,862.00$ 91,238.00$ 69,160.00$ 22,078.00
12/1/2013​
12​
December2013
GovernmentMexicoVTTLow
1940​
$ 250.00$ 350.00$ 679,000.00$ 13,580.00$ 665,420.00$ 504,400.00$ 161,020.00
12/1/2013​
12​
December2013
Small BusinessGermanyAmarillaLow
259​
$ 260.00$ 300.00$ 77,700.00$ 1,554.00$ 76,146.00$ 64,750.00$ 11,396.00
3/1/2014​
3​
March2014
Small BusinessMexicoAmarillaLow
1101​
$ 260.00$ 300.00$ 330,300.00$ 6,606.00$ 323,694.00$ 275,250.00$ 48,444.00
3/1/2014​
3​
March2014
EnterpriseGermanyAmarillaLow
2276​
$ 260.00$ 125.00$ 284,500.00$ 5,690.00$ 278,810.00$ 273,120.00$ 5,690.00
5/1/2014​
5​
May2014
GovernmentGermanyAmarillaLow
2966​
$ 260.00$ 350.00$ 1,038,100.00$ 20,762.00$ 1,017,338.00$ 771,160.00$ 246,178.00
10/1/2013​
10​
October2013
GovernmentUnited States of AmericaAmarillaLow
1236​
$ 260.00$ 20.00$ 24,720.00$ 494.40$ 24,225.60$ 12,360.00$ 11,865.60
11/1/2014​
11​
November2014
GovernmentFranceAmarillaLow
941​
$ 260.00$ 20.00$ 18,820.00$ 376.40$ 18,443.60$ 9,410.00$ 9,033.60
11/1/2014​
11​
November2014
Small BusinessCanadaAmarillaLow
1916​
$ 260.00$ 300.00$ 574,800.00$ 11,496.00$ 563,304.00$ 479,000.00$ 84,304.00
12/1/2014​
12​
December2014
EnterpriseFranceCarreteraLow
4243.5​
$ 3.00$ 125.00$ 530,437.50$ 15,913.13$ 514,524.38$ 509,220.00$ 5,304.38
4/1/2014​
4​
April2014
GovernmentGermanyCarreteraLow
2580​
$ 3.00$ 20.00$ 51,600.00$ 1,548.00$ 50,052.00$ 25,800.00$ 24,252.00
4/1/2014​
4​
April2014
Small BusinessGermanyCarreteraLow
689​
$ 3.00$ 300.00$ 206,700.00$ 6,201.00$ 200,499.00$ 172,250.00$ 28,249.00
6/1/2014​
6​
June2014
Channel PartnersUnited States of AmericaCarreteraLow
1947​
$ 3.00$ 12.00$ 23,364.00$ 700.92$ 22,663.08$ 5,841.00$ 16,822.08
9/1/2014​
9​
September2014
Channel PartnersCanadaCarreteraLow
908​
$ 3.00$ 12.00$ 10,896.00$ 326.88$ 10,569.12$ 2,724.00$ 7,845.12
12/1/2013​
12​
December2013
GovernmentGermanyMontanaLow
1958​
$ 5.00$ 7.00$ 13,706.00$ 411.18$ 13,294.82$ 9,790.00$ 3,504.82
2/1/2014​
2​
February2014
Channel PartnersFranceMontanaLow
1901​
$ 5.00$ 12.00$ 22,812.00$ 684.36$ 22,127.64$ 5,703.00$ 16,424.64
6/1/2014​
6​
June2014
GovernmentFranceMontanaLow
544​
$ 5.00$ 7.00$ 3,808.00$ 114.24$ 3,693.76$ 2,720.00$ 973.76
9/1/2014​
9​
September2014
GovernmentGermanyMontanaLow
1797​
$ 5.00$ 350.00$ 628,950.00$ 18,868.50$ 610,081.50$ 467,220.00$ 142,861.50
9/1/2013​
9​
September2013
EnterpriseFranceMontanaLow
1287​
$ 5.00$ 125.00$ 160,875.00$ 4,826.25$ 156,048.75$ 154,440.00$ 1,608.75
12/1/2014​
12​
December2014
EnterpriseGermanyMontanaLow
1706​
$ 5.00$ 125.00$ 213,250.00$ 6,397.50$ 206,852.50$ 204,720.00$ 2,132.50
12/1/2014​
12​
December2014
Small BusinessFrancePaseoLow
2434.5​
$ 10.00$ 300.00$ 730,350.00$ 21,910.50$ 708,439.50$ 608,625.00$ 99,814.50
1/1/2014​
1​
January2014
EnterpriseCanadaPaseoLow
1774​
$ 10.00$ 125.00$ 221,750.00$ 6,652.50$ 215,097.50$ 212,880.00$ 2,217.50
3/1/2014​
3​
March2014
Channel PartnersFrancePaseoLow
1901​
$ 10.00$ 12.00$ 22,812.00$ 684.36$ 22,127.64$ 5,703.00$ 16,424.64
6/1/2014​
6​
June2014
Small BusinessGermanyPaseoLow
689​
$ 10.00$ 300.00$ 206,700.00$ 6,201.00$ 200,499.00$ 172,250.00$ 28,249.00
6/1/2014​
6​
June2014
EnterpriseGermanyPaseoLow
1570​
$ 10.00$ 125.00$ 196,250.00$ 5,887.50$ 190,362.50$ 188,400.00$ 1,962.50
6/1/2014​
6​
June2014
Channel PartnersUnited States of AmericaPaseoLow
1369.5​
$ 10.00$ 12.00$ 16,434.00$ 493.02$ 15,940.98$ 4,108.50$ 11,832.48
7/1/2014​
7​
July2014
EnterpriseCanadaPaseoLow
2009​
$ 10.00$ 125.00$ 251,125.00$ 7,533.75$ 243,591.25$ 241,080.00$ 2,511.25
10/1/2014​
10​
October2014
MidmarketGermanyPaseoLow
1945​
$ 10.00$ 15.00$ 29,175.00$ 875.25$ 28,299.75$ 19,450.00$ 8,849.75
10/1/2013​
10​
October2013
EnterpriseFrancePaseoLow
1287​
$ 10.00$ 125.00$ 160,875.00$ 4,826.25$ 156,048.75$ 154,440.00$ 1,608.75
12/1/2014​
12​
December2014
EnterpriseGermanyPaseoLow
1706​
$ 10.00$ 125.00$ 213,250.00$ 6,397.50$ 206,852.50$ 204,720.00$ 2,132.50
12/1/2014​
12​
December2014
EnterpriseCanadaVeloLow
2009​
$ 120.00$ 125.00$ 251,125.00$ 7,533.75$ 243,591.25$ 241,080.00$ 2,511.25
10/1/2014​
10​
October2014
Small BusinessUnited States of AmericaVTTLow
2844​
$ 250.00$ 300.00$ 853,200.00$ 25,596.00$ 827,604.00$ 711,000.00$ 116,604.00
2/1/2014​
2​
February2014
Channel PartnersMexicoVTTLow
1916​
$ 250.00$ 12.00$ 22,992.00$ 689.76$ 22,302.24$ 5,748.00$ 16,554.24
4/1/2014​
4​
April2014
EnterpriseGermanyVTTLow
1570​
$ 250.00$ 125.00$ 196,250.00$ 5,887.50$ 190,362.50$ 188,400.00$ 1,962.50
6/1/2014​
6​
June2014
Small BusinessCanadaVTTLow
1874​
$ 250.00$ 300.00$ 562,200.00$ 16,866.00$ 545,334.00$ 468,500.00$ 76,834.00
8/1/2014​
8​
August2014
GovernmentMexicoVTTLow
1642​
$ 250.00$ 350.00$ 574,700.00$ 17,241.00$ 557,459.00$ 426,920.00$ 130,539.00
8/1/2014​
8​
August2014
MidmarketGermanyVTTLow
1945​
$ 250.00$ 15.00$ 29,175.00$ 875.25$ 28,299.75$ 19,450.00$ 8,849.75
10/1/2013​
10​
October2013
GovernmentCanadaCarreteraLow
831​
$ 3.00$ 20.00$ 16,620.00$ 498.60$ 16,121.40$ 8,310.00$ 7,811.40
5/1/2014​
5​
May2014
GovernmentMexicoPaseoLow
1760​
$ 10.00$ 7.00$ 12,320.00$ 369.60$ 11,950.40$ 8,800.00$ 3,150.40
9/1/2013​
9​
September2013
GovernmentCanadaVeloLow
3850.5​
$ 120.00$ 20.00$ 77,010.00$ 2,310.30$ 74,699.70$ 38,505.00$ 36,194.70
4/1/2014​
4​
April2014
Channel PartnersGermanyVTTLow
2479​
$ 250.00$ 12.00$ 29,748.00$ 892.44$ 28,855.56$ 7,437.00$ 21,418.56
1/1/2014​
1​
January2014
MidmarketMexicoMontanaLow
2031​
$ 5.00$ 15.00$ 30,465.00$ 1,218.60$ 29,246.40$ 20,310.00$ 8,936.40
10/1/2014​
10​
October2014
MidmarketMexicoPaseoLow
2031​
$ 10.00$ 15.00$ 30,465.00$ 1,218.60$ 29,246.40$ 20,310.00$ 8,936.40
10/1/2014​
10​
October2014
MidmarketFrancePaseoLow
2261​
$ 10.00$ 15.00$ 33,915.00$ 1,356.60$ 32,558.40$ 22,610.00$ 9,948.40
12/1/2013​
12​
December2013
GovernmentUnited States of AmericaVeloLow
736​
$ 120.00$ 20.00$ 14,720.00$ 588.80$ 14,131.20$ 7,360.00$ 6,771.20
9/1/2013​
9​
September2013
GovernmentCanadaCarreteraLow
2851​
$ 3.00$ 7.00$ 19,957.00$ 798.28$ 19,158.72$ 14,255.00$ 4,903.72
10/1/2013​
10​
October2013
Small BusinessGermanyCarreteraLow
2021​
$ 3.00$ 300.00$ 606,300.00$ 24,252.00$ 582,048.00$ 505,250.00$ 76,798.00
10/1/2014​
10​
October2014
GovernmentUnited States of AmericaCarreteraLow
274​
$ 3.00$ 350.00$ 95,900.00$ 3,836.00$ 92,064.00$ 71,240.00$ 20,824.00
12/1/2014​
12​
December2014
MidmarketCanadaMontanaLow
1967​
$ 5.00$ 15.00$ 29,505.00$ 1,180.20$ 28,324.80$ 19,670.00$ 8,654.80
3/1/2014​
3​
March2014
Small BusinessGermanyMontanaLow
1859​
$ 5.00$ 300.00$ 557,700.00$ 22,308.00$ 535,392.00$ 464,750.00$ 70,642.00
8/1/2014​
8​
August2014
GovernmentCanadaMontanaLow
2851​
$ 5.00$ 7.00$ 19,957.00$ 798.28$ 19,158.72$ 14,255.00$ 4,903.72
10/1/2013​
10​
October2013
Small BusinessGermanyMontanaLow
2021​
$ 5.00$ 300.00$ 606,300.00$ 24,252.00$ 582,048.00$ 505,250.00$ 76,798.00
10/1/2014​
10​
October2014
EnterpriseMexicoMontanaLow
1138​
$ 5.00$ 125.00$ 142,250.00$ 5,690.00$ 136,560.00$ 136,560.00$ -
12/1/2014​
12​
December2014
GovernmentCanadaPaseoLow
4251​
$ 10.00$ 7.00$ 29,757.00$ 1,190.28$ 28,566.72$ 21,255.00$ 7,311.72
1/1/2014​
1​
January2014


Sheet2 Data:


1/1/2013​
2/1/2013​
3/1/2013​
4/1/2013​
5/1/2013​
6/1/2013​
7/1/2013​
8/1/2013​
9/1/2013​
10/1/2013​
11/1/2013​
12/1/2013​
Canada
14548​
Germany
62291​
France
1235​
1257​
United States of America
Mexico
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

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