Hello All,
Hope you guys are doing great.
Here is the problem: I have values in Column D and it needs to be distributed to adjacent column i.e. Column B and C. The values assign to column B and C will changes the %age value of Column A.
I want help that how can i distribute values from Column D to B&C so that excel fill the values of that cell firstly which has lowest %age in column A. And %age of cells which are low come to an average value let say 65 or 70% as like other cells. And the highest value should assign to column B out of B&C
Hope you guys are doing great.
Here is the problem: I have values in Column D and it needs to be distributed to adjacent column i.e. Column B and C. The values assign to column B and C will changes the %age value of Column A.
I want help that how can i distribute values from Column D to B&C so that excel fill the values of that cell firstly which has lowest %age in column A. And %age of cells which are low come to an average value let say 65 or 70% as like other cells. And the highest value should assign to column B out of B&C
35% | 619 | ||
70% | 20 | ||
72% | 15 | ||
56% | 690 | ||
53% | 770 | ||
67% | 50 | ||
66% | 45 | ||
65% | 15 | ||
93% | 25 | ||
76% | 30 | ||
73% | 25 | ||
85% | 15 | ||
67% | 5 | ||
80% | 15 | ||
73% | 25 | ||
59% | 65 | ||
73% | 30 | ||
87% | 10 | ||
79% | 4 | ||
26% | 178 |
72% | 15 | ||
72% | 10 | ||
84% | 20 | ||
75% | 440 | ||
61% | 83 | ||