# Compare A Column And Allocate Percentages

#### Bruce Ratcliffe

##### New Member
Could anyone help me please with writing code for the following:

i) automatically compare a column of numbers and identify the largest value
ii) assign that largest value 100% and assign all other values the relative smaller percentage compared to the largest value
iii) automatically array the values top to bottom, largest to smallest

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Welcome Bruce,

If I understand your question correctly, this is what I propose.

Excel 2010
ABC
1110100%
25550%
310110%
Sheet1
Cell Formulas
RangeFormula
B1=LARGE(\$A\$1:\$A\$17,ROW(A1))
C2=B2/\$B\$1

Luke

Replies
3
Views
920
Replies
3
Views
619
Replies
0
Views
1K
Replies
1
Views
2K
Replies
1
Views
416

1,196,380
Messages
6,014,958
Members
441,857
Latest member
saraguchi2316

### 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.

### Which adblocker are you using?

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

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