Finally, she wants to know the market share for each product and region by month based on the PLE and industry sales data, and the average market share by region over the five years.

dont know how to do this in excel, if you just list the steps in how to find the market share for these two together that would be super helpful

AutoSave OFF Case Study 1 act Insert Home - Draw Page Layout Formulas Data Review View Tell me Share Comments v 12 Arial ~ Al A a Wras Text Insert v v X LG Ceneral AYO 5 DX Delete Pagic B 1 U UAY = = = Y Merge & Center v $ Ideas Conditional Format Cell Formatting as Table Styles Sort Filter Sensitivity Format Find & Select L91 . T D H L N O T Y D 4 IN VRNITVE. AD BA EUR Pallate Word 1 Apr A- 1 1 1 1 How 1 Fut-13 " 1 ! 1 1 SED 1 ! 1 1 Muth MA RA ELE chim World Month MA BA EURO .LY Pelin China World Moda NE 071 1211 14 Fob. 22 93 77136 202 91 1NN *111 F-14 14 7460 20 0 9 . Ma: 14 75 2210) 20 Feb-14 06 Wer-14 11 8120 250 T50 0 978 18120 Nord e 18 28 1781.1 Apr 14 290 TOU U 10 HEp.14 1811 5* 2705 SIS **21: Nie 14 11100 wucc 311 1501 Tu U 11 Jan. I 50 % E D Jun-14 M 300 18 Jul-H y 1221 TXT XD ID TES 2-14 Aug-14 1981 18 14 MTD TEM 7.41 LY 20 D 10141 Aug-14 250 1 14 wp- BIT 1970 LR) 2161 RS Aug-14 HRC 731 1992 tm O. 380 311 Sep 14 . ATTE O 14 223 1220 0 TE NEC Non 2137 333 O-14 12000 71902 11 Ge! 213 30 0 Dec 14 45.43 2 124 30 Nov.14 05545 Due 14 464: 150 10 Jun-13 be21 0 sas 12778 401 D-16 Jan 15 5060 U 10 23 a's 12212 RE F-15 1320 750 U Mer 13 NU 3 Feb-15 D Apr 15 112 1231 WED 2 N-15 D TE 200 Apr May-15 1221 121 Arts R011 WE MI 215 D Nyt 2015 1 on Jan 15 R0031 an 77112 M-15 20 Jun16 1991 10 12 Jul 15 223 YA * Aug. 15 74554 720 2721 . 23 0164 A 16 771: 1530 30 0 SO EP 15 24. Aup 16 an 21 29 8-11 250 0-13 . 1530 20 0 23714 2310 56e92 au 8145 Oct-13 250 Nge-13 1250 0 Std Oct-19 46122 3/1 19 Nov-15 uc 200 U SU Dec 15 474 912 Now-15 4360 211 TV n. 10 SH STT 1290 Desis D TYG In-16 RECE 521 12 wym Fah-18 Jun1 17 12 WC D WA rah. THE 291 111 0 M18 BE11 Feb-16 329 27: War 16 Se 111 m 0 276 Am Ci 22 N-16 * 211 Apr 16 O! 153 171 0 16 an Ar 16 Nie biro TO May 16 140 30 0 38 Jun 10 100 1780 22 24 660 27601 May 16 $90 J.-13 TUS! 1450 242 110 0 TO Just 6810 561 115215 Aug. 13 Jul-10 W060 313 1440 U ULI 30 1987 25 Ju116 D S. A.16 14' U Sep. 15 N001 Au-16 D 5-16 1420 O.14 D ED 3959 13 Sep-16 D TTIPO De 12 3 220 W w Now 10 Dd-16 17. AD D Nov 16 701 111 19 21 n Dec-16 4999 OT No.16 7211 CAS Dec 16 731 0 .Lm 17 91 22 3771 Deo-16 ART ab 220 45 Fob 17 0 76530 94 13 25 AL Jan 17 91162 F17 0 War. 12 B20 12 be Feb 17 Wer 17 84. - 250 1140 200 0 Apr. 17 10 127 70030 1381 T! Nr.1 Apr 12 1410 - 9112 May-17 U 20 YOU 23 100 TS Asr-Y 10 N-13 930 380 Jan-17 1341 NU U 1840 Marin 17 92 NE Jun. 12 10120 1991 2001 J-17 1331 M TAP IT 217.IT ZD 7. Jul 19 sec 1110 2 Aug-17 TUM 926 221 100 MO 123 LITE A.19 TOS 340 1191 ax 20 0 Sup. 17 310 910 M299 NITY 7 AuEIT) AT.1 5.12 134 5-7 2016 M 2100 17 Spot 10 7171 Od 17 21 How 12 13 2.0 Ox-17 37 13720 67105 Nov 12 Dec-17 51238 391 720 0 1918 6330 Nov.17 2160 De 1 430 0 300 Jun-19 502 IST 852 RE Dec-17 Jan-18 621: 430 200 U Fut-19 041 USU 3/1 16 da. 10 SUBS 290 250 7 U Mer. 18 193 Feb-18 bra D 09544 W Mar 1 1848 2049 290 DES Apr. 13 PC97 299 N18 A TICS Apr 16 2120 1310 221 16 10 PILI SIN. UIT Aero 52 390 PO N-I 22 1991 292 25.4 PRIM 19 ATY 23 J. M-10 tros 31 20 1711 HE 12. R3 710 23 2171 21 RE 353 1191 21 12 Aug 13 14 16 733 2037 1186 01661 A 16 7661 1230 220 16 26 | 27 be:3 2320 2016 Aup 18 04.13 1 8-16 12.90 3831 564. 500 2012 56 84-18 Oct 10 US 12 SU No. 13 Oct-18 51.84 Hirs 21202 D Nov 1 560 su 20 1 Der Nov-18 LAH 3 FIL 23 29 0 TOS 36.33 123723 NYM SOR TOES YEH TEN 60 TO 18 MomMAER china Mon NA 84 12 HER EZ 223 16033 LOT Feb14 SC 293 1693 F-14 611 Nor-14 50 270 TULE 6091 1122 28 17123 Nor-14 SU Ar-14 230 TU bbt 120 19 1/327 Asr 14 4 Mata 200 "Ibu 1221 290 12.10 Ma-14 JU-14 UID FI 1397 297 15141 JU 60 14 20 STY TINE 1354 213 15925 512 Au-14 14 WD STRE 1201 297 14172 Aus-14 20 Sep- 1092 1200 701 Sep-14 14 TOE 1103 297 14931 14 ao Nov.14 TOTE 1127 298 15018 Nov.14 00 Deo-14 31$ 20 TUCS 44 1065 SO Deo-14 200 250 18 See 1155 sod 14223 19 71 SO F-15 re 1250 322 1653J Pats Narcis R1 200 201 17281 Nar-15 Arts STTY 1612 TEC 1940 337 13 Aprus IND M-16 20 1721 13 359 11M MH R15 rec 1449 3:13 1979 . TY G 776 1422 815 1117 61 Aup.16 03 6762 11661 1443 818 16230 Sep-16 Aup 16 0 1504 22 15.2 Sep-16 60 Oct-15 3345 460 1815 S11 1250 913 1454 Oct.15 440 No15 405 1564 121 314 14412 N15 435 Dets 221 JEG De-15 TICS 29 128 211 1197 J-16 Feb-16 SID 2115 1211 31 1LY Fat16 780 Na-16 212 FR 10 7255 1214 19 1649 Nr-16 ARO Aer 16 MB 2161 Bere 1811 0 16422 Ar 10 May 16 2914 701 1415 580 " May 16 JU 2110 161 15. 20030 Ju-16 is HU 2110 1625 57: 117 JU16 006 50 Aup-16 2125 CAC 1584 291 165, Aup-16 HO Sep-16 ON 2 1997 20 Dict-16 Sep-16 120 2210 RE 712 1EM Oct-16 T.D ICO -16 9 ro 12.00 741 1ST No.16 re 1980 TID 1203 19 102TT Des-16 GT 601 711 Feb 17 Jan 10 BOE 1488 123 1/28 Feb 17 Narty 24 1423 1254 1500 Narty 160 Asr-IY 724 1604 1512 1:33 20! MET 1988 2012 M2 Apr.tv 1550 MET JURIT nep A2 the 2291 LUIT 30 SIC HO HIT 1721 25411 MHT THE Aup-IT on MA GIR 1700 1911 Aus-17 . ME SAT far 1143 2011 74121 SET Ron C-17 2010 CRM 105 2121 2002 C-17 Nov.17 AN 7900 2746 1453 2292 15729 Nov.17 D-17 2354 8 be 1450 2843 15:23 Doe- TUS Site 1013 2232 15811 18 0 Feb-18 2000 404542 Z4IT NE Feb-18 u 16 zne 1100 2931 204 Apr- Nar-18 PC 1150 22T Apr- Main 12120 2141 MID 1241 7051 2541 M 120 L-1AVIA 2H11 1307 2011 hvor RO . 2 1431 2001 Aup 1822763 . 6064 123 2343 Sep-18 19 20 Aup-18 1123 2453 Sep-18 2150 Oct 18 ter SIS1 1129 no N18 Oct.18 USU 96 SE4 104 Nor18 29 UM TO 4530 Troll 38610 TH 111 Same 1 1 " 2105 204 I Del Enerse Nobel Market Share Industry Tractor Total Sales Unit Production Costs Operating & Interest Expenses On-Time Delivery Defects After Delivery + Grass Ravenues Industry Mower Total Sales Select destination and press ENTER or choose Paste + 65% AutoSave OFF Case Study 1 act Insert Home - Draw Page Layout Formulas Data Review View Tell me Share Comments v 12 Arial ~ Al A a Wras Text Insert v v X LG Ceneral AYO 5 DX Delete Pagic B 1 U UAY = = = Y Merge & Center v $ Ideas Conditional Format Cell Formatting as Table Styles Sort Filter Sensitivity Format Find & Select L91 . T D H L N O T Y D 4 IN VRNITVE. AD BA EUR Pallate Word 1 Apr A- 1 1 1 1 How 1 Fut-13 " 1 ! 1 1 SED 1 ! 1 1 Muth MA RA ELE chim World Month MA BA EURO .LY Pelin China World Moda NE 071 1211 14 Fob. 22 93 77136 202 91 1NN *111 F-14 14 7460 20 0 9 . Ma: 14 75 2210) 20 Feb-14 06 Wer-14 11 8120 250 T50 0 978 18120 Nord e 18 28 1781.1 Apr 14 290 TOU U 10 HEp.14 1811 5* 2705 SIS **21: Nie 14 11100 wucc 311 1501 Tu U 11 Jan. I 50 % E D Jun-14 M 300 18 Jul-H y 1221 TXT XD ID TES 2-14 Aug-14 1981 18 14 MTD TEM 7.41 LY 20 D 10141 Aug-14 250 1 14 wp- BIT 1970 LR) 2161 RS Aug-14 HRC 731 1992 tm O. 380 311 Sep 14 . ATTE O 14 223 1220 0 TE NEC Non 2137 333 O-14 12000 71902 11 Ge! 213 30 0 Dec 14 45.43 2 124 30 Nov.14 05545 Due 14 464: 150 10 Jun-13 be21 0 sas 12778 401 D-16 Jan 15 5060 U 10 23 a's 12212 RE F-15 1320 750 U Mer 13 NU 3 Feb-15 D Apr 15 112 1231 WED 2 N-15 D TE 200 Apr May-15 1221 121 Arts R011 WE MI 215 D Nyt 2015 1 on Jan 15 R0031 an 77112 M-15 20 Jun16 1991 10 12 Jul 15 223 YA * Aug. 15 74554 720 2721 . 23 0164 A 16 771: 1530 30 0 SO EP 15 24. Aup 16 an 21 29 8-11 250 0-13 . 1530 20 0 23714 2310 56e92 au 8145 Oct-13 250 Nge-13 1250 0 Std Oct-19 46122 3/1 19 Nov-15 uc 200 U SU Dec 15 474 912 Now-15 4360 211 TV n. 10 SH STT 1290 Desis D TYG In-16 RECE 521 12 wym Fah-18 Jun1 17 12 WC D WA rah. THE 291 111 0 M18 BE11 Feb-16 329 27: War 16 Se 111 m 0 276 Am Ci 22 N-16 * 211 Apr 16 O! 153 171 0 16 an Ar 16 Nie biro TO May 16 140 30 0 38 Jun 10 100 1780 22 24 660 27601 May 16 $90 J.-13 TUS! 1450 242 110 0 TO Just 6810 561 115215 Aug. 13 Jul-10 W060 313 1440 U ULI 30 1987 25 Ju116 D S. A.16 14' U Sep. 15 N001 Au-16 D 5-16 1420 O.14 D ED 3959 13 Sep-16 D TTIPO De 12 3 220 W w Now 10 Dd-16 17. AD D Nov 16 701 111 19 21 n Dec-16 4999 OT No.16 7211 CAS Dec 16 731 0 .Lm 17 91 22 3771 Deo-16 ART ab 220 45 Fob 17 0 76530 94 13 25 AL Jan 17 91162 F17 0 War. 12 B20 12 be Feb 17 Wer 17 84. - 250 1140 200 0 Apr. 17 10 127 70030 1381 T! Nr.1 Apr 12 1410 - 9112 May-17 U 20 YOU 23 100 TS Asr-Y 10 N-13 930 380 Jan-17 1341 NU U 1840 Marin 17 92 NE Jun. 12 10120 1991 2001 J-17 1331 M TAP IT 217.IT ZD 7. Jul 19 sec 1110 2 Aug-17 TUM 926 221 100 MO 123 LITE A.19 TOS 340 1191 ax 20 0 Sup. 17 310 910 M299 NITY 7 AuEIT) AT.1 5.12 134 5-7 2016 M 2100 17 Spot 10 7171 Od 17 21 How 12 13 2.0 Ox-17 37 13720 67105 Nov 12 Dec-17 51238 391 720 0 1918 6330 Nov.17 2160 De 1 430 0 300 Jun-19 502 IST 852 RE Dec-17 Jan-18 621: 430 200 U Fut-19 041 USU 3/1 16 da. 10 SUBS 290 250 7 U Mer. 18 193 Feb-18 bra D 09544 W Mar 1 1848 2049 290 DES Apr. 13 PC97 299 N18 A TICS Apr 16 2120 1310 221 16 10 PILI SIN. UIT Aero 52 390 PO N-I 22 1991 292 25.4 PRIM 19 ATY 23 J. M-10 tros 31 20 1711 HE 12. R3 710 23 2171 21 RE 353 1191 21 12 Aug 13 14 16 733 2037 1186 01661 A 16 7661 1230 220 16 26 | 27 be:3 2320 2016 Aup 18 04.13 1 8-16 12.90 3831 564. 500 2012 56 84-18 Oct 10 US 12 SU No. 13 Oct-18 51.84 Hirs 21202 D Nov 1 560 su 20 1 Der Nov-18 LAH 3 FIL 23 29 0 TOS 36.33 123723 NYM SOR TOES YEH TEN 60 TO 18 MomMAER china Mon NA 84 12 HER EZ 223 16033 LOT Feb14 SC 293 1693 F-14 611 Nor-14 50 270 TULE 6091 1122 28 17123 Nor-14 SU Ar-14 230 TU bbt 120 19 1/327 Asr 14 4 Mata 200 "Ibu 1221 290 12.10 Ma-14 JU-14 UID FI 1397 297 15141 JU 60 14 20 STY TINE 1354 213 15925 512 Au-14 14 WD STRE 1201 297 14172 Aus-14 20 Sep- 1092 1200 701 Sep-14 14 TOE 1103 297 14931 14 ao Nov.14 TOTE 1127 298 15018 Nov.14 00 Deo-14 31$ 20 TUCS 44 1065 SO Deo-14 200 250 18 See 1155 sod 14223 19 71 SO F-15 re 1250 322 1653J Pats Narcis R1 200 201 17281 Nar-15 Arts STTY 1612 TEC 1940 337 13 Aprus IND M-16 20 1721 13 359 11M MH R15 rec 1449 3:13 1979 . TY G 776 1422 815 1117 61 Aup.16 03 6762 11661 1443 818 16230 Sep-16 Aup 16 0 1504 22 15.2 Sep-16 60 Oct-15 3345 460 1815 S11 1250 913 1454 Oct.15 440 No15 405 1564 121 314 14412 N15 435 Dets 221 JEG De-15 TICS 29 128 211 1197 J-16 Feb-16 SID 2115 1211 31 1LY Fat16 780 Na-16 212 FR 10 7255 1214 19 1649 Nr-16 ARO Aer 16 MB 2161 Bere 1811 0 16422 Ar 10 May 16 2914 701 1415 580 " May 16 JU 2110 161 15. 20030 Ju-16 is HU 2110 1625 57: 117 JU16 006 50 Aup-16 2125 CAC 1584 291 165, Aup-16 HO Sep-16 ON 2 1997 20 Dict-16 Sep-16 120 2210 RE 712 1EM Oct-16 T.D ICO -16 9 ro 12.00 741 1ST No.16 re 1980 TID 1203 19 102TT Des-16 GT 601 711 Feb 17 Jan 10 BOE 1488 123 1/28 Feb 17 Narty 24 1423 1254 1500 Narty 160 Asr-IY 724 1604 1512 1:33 20! MET 1988 2012 M2 Apr.tv 1550 MET JURIT nep A2 the 2291 LUIT 30 SIC HO HIT 1721 25411 MHT THE Aup-IT on MA GIR 1700 1911 Aus-17 . ME SAT far 1143 2011 74121 SET Ron C-17 2010 CRM 105 2121 2002 C-17 Nov.17 AN 7900 2746 1453 2292 15729 Nov.17 D-17 2354 8 be 1450 2843 15:23 Doe- TUS Site 1013 2232 15811 18 0 Feb-18 2000 404542 Z4IT NE Feb-18 u 16 zne 1100 2931 204 Apr- Nar-18 PC 1150 22T Apr- Main 12120 2141 MID 1241 7051 2541 M 120 L-1AVIA 2H11 1307 2011 hvor RO . 2 1431 2001 Aup 1822763 . 6064 123 2343 Sep-18 19 20 Aup-18 1123 2453 Sep-18 2150 Oct 18 ter SIS1 1129 no N18 Oct.18 USU 96 SE4 104 Nor18 29 UM TO 4530 Troll 38610 TH 111 Same 1 1 " 2105 204 I Del Enerse Nobel Market Share Industry Tractor Total Sales Unit Production Costs Operating & Interest Expenses On-Time Delivery Defects After Delivery + Grass Ravenues Industry Mower Total Sales Select destination and press ENTER or choose Paste + 65%