• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel tool for distributing value

Vishal66

New Member
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

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
 
Vishal66
As a new member ...
Did You read below link,
before You pressed [Post reply]?
There are good advices and so on, how to get great answers.
 
Back
Top