troubleshooting Question

excel ranking amounts

Avatar of Professor J
Professor J asked on
Microsoft Excel
14 Comments1 Solution127 ViewsLast Modified:
I have in column A the amounts.  in column be i want to give them ranks between 1 to 20  
the buffer for change from one rank to another would be 5% one rank to another.  


please let me know if it is not clear.



Column of Amount
254206
324168
358382
514388
564586
832547
884214
1055234
1155106
1218166
1245709
1446298
1796747
1894497
1921254
1933139
2077290
2106388
2169413
2469810
2530759
2537173
2563622
2948527
2959577
2973120
3006114
3135950
3436625
3472997
3862000
3979547
4129793
4298024
4327374
4616533
4703680
226050
710630
343289
640780
43112
171384
495652
324096
923858
267228
16080
108425
423669
190244
348497
559542
470272
893880
738767
5370
524890
562580
289573
92572
136084
407428
235285
177762
814444
276129
306647
363127
853137
990962
911198
816955
396386
755812
891251
805960
870217
136734
854708
768971
629077
819388
53249
74475
439187
506479
386426
536908
865897
617993
944542
468073
881403
165268
732619
681233
581530
936041
484106
155943
384404
622574
11973
711421
712959
212978
116718
733530
210305
141837
476925
698801
755127
315227
285640
345150
289508
508367
749213
942175
81675
416097
342962
420082
432934
797041
669615
457386
635410
34325
99114
54117
40906
57895
712993
168773
375857
145545
366554
649508
162810
139857
398807
988915
525621
217428
219122
549144
29465
592861
945075
844096
155770
686463
978360
85228
325219
934875
625440
849943
105864
697170
457251
254805
990284
978012
38696
544446
938388
ASKER CERTIFIED SOLUTION
johnb25

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros