Spreadsheet: 680662d1591126558-percentile-formula-not-working-sample-workbook
Sheet: Sheet1

 | Values |  |  |  | Value % of Total Universe | # of Stores
store | share | units sold |  | Key Stores | 0.8
1 | 0.01851498377552968 | 2037 |  | Current State
2 | 0.01532462574646198 | 1686 |  | Target
3 | 0.01407029694870886 | 1548
4 | 0.01287050418564066 | 1416
5 | 0.01243421590816132 | 1368
6 | 0.01082540288495623 | 1191
7 | 0.01082540288495623 | 1191
8 | 0.009680146156572955 | 1065
9 | 0.009489270035175742 | 1044
10 | 0.008916641670984103 | 981
11 | 0.008889373653641643 | 978
12 | 0.008507621410847217 | 936
13 | 0.008180405202737709 | 900
14 | 0.008071333133367872 | 888
15 | 0.008044065116025415 | 885
16 | 0.007689580890573446 | 846
17 | 0.007444168734491315 | 819
18 | 0.007062416491696889 | 777
19 | 0.006898808387642135 | 759
20 | 0.006817004335614757 | 750
21 | 0.006762468300929839 | 744
22 | 0.006762468300929839 | 744
23 | 0.006407984075477872 | 705
24 | 0.006380716058135413 | 702
25 | 0.006380716058135413 | 702
26 | 0.006326180023450495 | 696
27 | 0.006244375971423118 | 687
28 | 0.006244375971423118 | 687
29 | 0.006244375971423118 | 687
30 | 0.0061898399367382 | 681
31 | 0.00616257191939574 | 678
32 | 0.005917159763313609 | 651
33 | 0.005862623728628691 | 645
34 | 0.005753551659258855 | 633
35 | 0.005726283641916396 | 630
36 | 0.005671747607231478 | 624
37 | 0.005671747607231478 | 624
38 | 0.00561721157254656 | 618
39 | 0.005589943555204101 | 615
40 | 0.005208191312409675 | 573
41 | 0.005153655277724756 | 567
42 | 0.005153655277724756 | 567
43 | 0.005153655277724756 | 567
44 | 0.005126387260382298 | 564
45 | 0.00507185122569738 | 558
46 | 0.00504458320835492 | 555
47 | 0.00504458320835492 | 555
48 | 0.00504458320835492 | 555
49 | 0.004990047173670002 | 549
50 | 0.004908243121642625 | 540
51 | 0.004880975104300167 | 537
52 | 0.004853707086957707 | 534
53 | 0.004799171052272789 | 528
54 | 0.004717367000245412 | 519
55 | 0.004717367000245412 | 519
56 | 0.004690098982902953 | 516
57 | 0.004635562948218035 | 510
58 | 0.004608294930875576 | 507
59 | 0.004581026913533117 | 504
60 | 0.004553758896190658 | 501
61 | 0.004553758896190658 | 501
62 | 0.00449922286150574 | 495
63 | 0.004471954844163281 | 492
64 | 0.004362882774793445 | 480
65 | 0.004308346740108527 | 474
66 | 0.004308346740108527 | 474
67 | 0.004281078722766067 | 471
68 | 0.004281078722766067 | 471
69 | 0.00422654268808115 | 465
70 | 0.004117470618711314 | 453
71 | 0.004090202601368854 | 450
72 | 0.004035666566683936 | 444
73 | 0.004035666566683936 | 444
74 | 0.004035666566683936 | 444
75 | 0.003981130531999018 | 438
76 | 0.003981130531999018 | 438
77 | 0.0039265944973141 | 432
78 | 0.0039265944973141 | 432
79 | 0.003899326479971641 | 429
80 | 0.003899326479971641 | 429
81 | 0.003844790445286723 | 423
82 | 0.003844790445286723 | 423
83 | 0.003790254410601805 | 417
84 | 0.003762986393259346 | 414
85 | 0.003735718375916887 | 411
86 | 0.003735718375916887 | 411
87 | 0.00365391432388951 | 402
88 | 0.003626646306547051 | 399
89 | 0.003626646306547051 | 399
90 | 0.003544842254519674 | 390
91 | 0.003517574237177215 | 387
92 | 0.003463038202492297 | 381
93 | 0.003463038202492297 | 381
94 | 0.003408502167807379 | 375
95 | 0.003408502167807379 | 375
96 | 0.003381234150464919 | 372
97 | 0.003381234150464919 | 372
98 | 0.003381234150464919 | 372
99 | 0.003381234150464919 | 372
100 | 0.003353966133122461 | 369
101 | 0.003353966133122461 | 369
102 | 0.003299430098437543 | 363
103 | 0.003299430098437543 | 363
104 | 0.003272162081095084 | 360
105 | 0.003272162081095084 | 360
106 | 0.003272162081095084 | 360
107 | 0.003244894063752625 | 357
108 | 0.003244894063752625 | 357
109 | 0.003217626046410166 | 354
110 | 0.003217626046410166 | 354
111 | 0.003190358029067706 | 351
112 | 0.003163090011725247 | 348
113 | 0.003135821994382788 | 345
114 | 0.003135821994382788 | 345
115 | 0.003135821994382788 | 345
116 | 0.003108553977040329 | 342
117 | 0.003108553977040329 | 342
118 | 0.00308128595969787 | 339
119 | 0.00308128595969787 | 339
120 | 0.00308128595969787 | 339
121 | 0.00308128595969787 | 339
122 | 0.003054017942355411 | 336
123 | 0.003054017942355411 | 336
124 | 0.003026749925012952 | 333
125 | 0.003026749925012952 | 333
126 | 0.002999481907670493 | 330
127 | 0.002944945872985575 | 324
128 | 0.002890409838300657 | 318
129 | 0.002890409838300657 | 318
130 | 0.002890409838300657 | 318
131 | 0.002835873803615739 | 312
132 | 0.002835873803615739 | 312
133 | 0.002835873803615739 | 312
134 | 0.002835873803615739 | 312
135 | 0.002835873803615739 | 312
136 | 0.002781337768930821 | 306
137 | 0.002781337768930821 | 306
138 | 0.002781337768930821 | 306
139 | 0.002754069751588362 | 303
140 | 0.002726801734245903 | 300
141 | 0.002726801734245903 | 300
142 | 0.002726801734245903 | 300
143 | 0.002699533716903444 | 297
144 | 0.002699533716903444 | 297
145 | 0.002699533716903444 | 297
146 | 0.002699533716903444 | 297
147 | 0.002672265699560985 | 294
148 | 0.002644997682218526 | 291
149 | 0.002644997682218526 | 291
150 | 0.002644997682218526 | 291
151 | 0.002644997682218526 | 291
152 | 0.002617729664876067 | 288
153 | 0.002617729664876067 | 288
154 | 0.002617729664876067 | 288
155 | 0.002617729664876067 | 288
156 | 0.002617729664876067 | 288
157 | 0.002617729664876067 | 288
158 | 0.002617729664876067 | 288
159 | 0.002590461647533608 | 285
160 | 0.002590461647533608 | 285
161 | 0.002590461647533608 | 285
162 | 0.002590461647533608 | 285
163 | 0.002563193630191149 | 282
164 | 0.002563193630191149 | 282
165 | 0.002563193630191149 | 282
166 | 0.00253592561284869 | 279
167 | 0.00253592561284869 | 279
168 | 0.002481389578163772 | 273
169 | 0.002481389578163772 | 273
170 | 0.002481389578163772 | 273
171 | 0.002454121560821313 | 270
172 | 0.002426853543478854 | 267
173 | 0.002426853543478854 | 267
174 | 0.002399585526136395 | 264
175 | 0.002399585526136395 | 264
176 | 0.002399585526136395 | 264
177 | 0.002372317508793935 | 261
178 | 0.002372317508793935 | 261
179 | 0.002372317508793935 | 261
180 | 0.002372317508793935 | 261
181 | 0.002317781474109017 | 255
182 | 0.002290513456766559 | 252
183 | 0.002290513456766559 | 252
184 | 0.002290513456766559 | 252
185 | 0.0022632454394241 | 249
186 | 0.002235977422081641 | 246
187 | 0.002235977422081641 | 246
188 | 0.002235977422081641 | 246
189 | 0.002235977422081641 | 246
190 | 0.002208709404739182 | 243
191 | 0.002154173370054263 | 237
192 | 0.002126905352711804 | 234
193 | 0.002099637335369345 | 231
194 | 0.002099637335369345 | 231
195 | 0.002072369318026886 | 228
196 | 0.002072369318026886 | 228
197 | 0.002045101300684427 | 225
198 | 0.002045101300684427 | 225
199 | 0.002017833283341968 | 222
200 | 0.001990565265999509 | 219
201 | 0.00196329724865705 | 216
202 | 0.00196329724865705 | 216
203 | 0.00196329724865705 | 216
204 | 0.00196329724865705 | 216
205 | 0.00196329724865705 | 216
206 | 0.00196329724865705 | 216
207 | 0.00196329724865705 | 216
208 | 0.00196329724865705 | 216
209 | 0.00196329724865705 | 216
210 | 0.00196329724865705 | 216
211 | 0.00196329724865705 | 216
212 | 0.001936029231314591 | 213
213 | 0.001936029231314591 | 213
214 | 0.001936029231314591 | 213
215 | 0.001936029231314591 | 213
216 | 0.001908761213972132 | 210
217 | 0.001908761213972132 | 210
218 | 0.001908761213972132 | 210
219 | 0.001908761213972132 | 210
220 | 0.001908761213972132 | 210
221 | 0.001881493196629673 | 207
222 | 0.001881493196629673 | 207
223 | 0.001881493196629673 | 207
224 | 0.001881493196629673 | 207
225 | 0.001881493196629673 | 207
226 | 0.001854225179287214 | 204
227 | 0.001854225179287214 | 204
228 | 0.001854225179287214 | 204
229 | 0.001826957161944755 | 201
230 | 0.001826957161944755 | 201
231 | 0.001799689144602296 | 198
232 | 0.001799689144602296 | 198
233 | 0.001772421127259837 | 195
234 | 0.001745153109917378 | 192
235 | 0.001745153109917378 | 192
236 | 0.001717885092574919 | 189
237 | 0.00169061707523246 | 186
238 | 0.001663349057890001 | 183
239 | 0.001608813023205083 | 177
240 | 0.001581545005862624 | 174
241 | 0.001581545005862624 | 174
242 | 0.001581545005862624 | 174
243 | 0.001554276988520165 | 171
244 | 0.001554276988520165 | 171
245 | 0.001554276988520165 | 171
246 | 0.001527008971177706 | 168
247 | 0.001527008971177706 | 168
248 | 0.001527008971177706 | 168
249 | 0.001499740953835247 | 165
250 | 0.001499740953835247 | 165
251 | 0.001472472936492788 | 162
252 | 0.001445204919150329 | 159
253 | 0.001445204919150329 | 159
254 | 0.001445204919150329 | 159
255 | 0.001445204919150329 | 159
256 | 0.00141793690180787 | 156
257 | 0.00141793690180787 | 156
258 | 0.00139066888446541 | 153
259 | 0.001363400867122951 | 150
260 | 0.001363400867122951 | 150
261 | 0.001336132849780492 | 147
262 | 0.001308864832438034 | 144
263 | 0.001308864832438034 | 144
264 | 0.001308864832438034 | 144
265 | 0.001281596815095574 | 141
266 | 0.001281596815095574 | 141
267 | 0.001227060780410656 | 135
268 | 0.001227060780410656 | 135
269 | 0.001227060780410656 | 135
270 | 0.001199792763068197 | 132
271 | 0.001199792763068197 | 132
272 | 0.001172524745725738 | 129
273 | 0.001145256728383279 | 126
274 | 0.001145256728383279 | 126
275 | 0.001145256728383279 | 126
276 | 0.00111798871104082 | 123
277 | 0.001036184659013443 | 114
278 | 0.001008916641670984 | 111
279 | 0.000981648624328525 | 108
280 | 0.000954380606986066 | 105
281 | 0.000899844572301148 | 99
282 | 0.000899844572301148 | 99
283 | 0.000899844572301148 | 99
284 | 0.0008725765549586889 | 96
285 | 0.0008725765549586889 | 96
286 | 0.0008725765549586889 | 96
287 | 0.0008725765549586889 | 96
288 | 0.0008453085376162299 | 93
289 | 0.0008180405202737709 | 90
290 | 0.0007907725029313119 | 87
291 | 0.0007635044855888528 | 84
292 | 0.0007635044855888528 | 84
293 | 0.0007362364682463938 | 81
294 | 0.0007362364682463938 | 81
295 | 0.0007362364682463938 | 81
296 | 0.0007362364682463938 | 81
297 | 0.0007089684509039348 | 78
298 | 0.0007089684509039348 | 78
299 | 0.0007089684509039348 | 78
300 | 0.0007089684509039348 | 78
301 | 0.0007089684509039348 | 78
302 | 0.0007089684509039348 | 78
303 | 0.0006817004335614757 | 75
304 | 0.0006544324162190168 | 72
305 | 0.0006544324162190168 | 72
306 | 0.0006544324162190168 | 72
307 | 0.0006544324162190168 | 72
308 | 0.0006544324162190168 | 72
309 | 0.0006544324162190168 | 72
310 | 0.0005998963815340986 | 66
311 | 0.0005998963815340986 | 66
312 | 0.0005998963815340986 | 66
313 | 0.0005453603468491806 | 60
314 | 0.0005180923295067215 | 57
315 | 0.0005180923295067215 | 57
316 | 0.0004635562948218035 | 51
317 | 0.0004635562948218035 | 51
318 | 0.0004362882774793445 | 48
319 | 0.0004362882774793445 | 48
320 | 0.0003817522427944264 | 42
321 | 0.0003817522427944264 | 42
322 | 0.0003272162081095084 | 36
323 | 0.0002726801734245903 | 30
324 | 0.0002726801734245903 | 30
325 | 0.0002454121560821312 | 27
326 | 0.0002181441387396722 | 24
327 | 0.0002181441387396722 | 24
328 | 0.0001636081040547542 | 18
329 | 0.0001363400867122952 | 15
330 | 0.0001363400867122952 | 15
331 | 0.0001363400867122952 | 15
332 | 0.0001363400867122952 | 15
333 | 8.18040520273771e-05 | 9
334 | 8.18040520273771e-05 | 9
335 | 5.453603468491806e-05 | 6
336 | 5.453603468491806e-05 | 6
337 | 5.453603468491806e-05 | 6
338 | 5.453603468491806e-05 | 6
339 | 5.453603468491806e-05 | 6
340 | 2.726801734245903e-05 | 3
341 | 2.726801734245903e-05 | 3
342 | 2.726801734245903e-05 | 3
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680