Good afternoon Gentlemen, I have a column of data, with a varying number of percentage values that add up to 100%, separated by "NA", i.e.
33%
33%
33%
NA
25%
25%
25%
25%
NA
100%
NA
20%
20%
20%
20%
20%
NA
Now... when I change one of the values I would like the others to even up, i.e. in the last example if I change a 20% to 50% I would like the others to change to 10%... any ideas?
Last edited by ChrisMattock; 01-12-2009 at 09:49 AM.
This will work if you change the NA to blank cells:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Hmm, it changes all the values, despite the fact they are now separated by "" rather than "NA". The data does noit start until Row 11, would that make a difference?
I don't know what you mean by "", but the code requires a blank cell, meaning nothing in it.
Edit: Actually, Chris, it requires the columns on either side of the blanks to be blank as well, since that affects the vertical aspect of the CurrentRegion of a cell.
Edit2: Post a workbook.
Last edited by shg; 01-08-2009 at 04:29 PM.
That's what I meant by a blank cell, there is nothing in it.
EDIT: I just tried it where I manually enter the percentages on a spare sheet and it works perfectly, just not on the one generated by my macro. :S
EDIT2: Ah, is there a way round this, without putting those additional columns in?
Last edited by ChrisMattock; 01-08-2009 at 04:34 PM.
OK. Post a workbook.
Here is an example of how my output page will look, the percentages that need to auto adjust are in the Weighting Column. Thanks for the help I appreciate it.
Code gets ugly ...
Please Login or Register to view this content.
You are an absolute star. That is perfect! Thanks for your help, +rep to you!
Good afternoon Gentlemen, Yesterday shg was kind enough to help with the following problem...
I have a column of data, with a varying number of percentage values that add up to 100%, separated by "NA", i.e.
33%
33%
33%
NA
25%
25%
25%
25%
NA
100%
NA
20%
20%
20%
20%
20%
NA
The solution was:
Now the problem I have is that I want to adjust several of the percentages, the first one I adjust the remaining should adjust, then when I adjust the second all of them except the one I have already adjust should change... i.e.Please Login or Register to view this content.
If I have the following
20%
20%
20%
20%
20%
And I change the first one...
50%
12.5%
12.5%
12.5%
12.5%
Then the next one I change should yield the following result
50%
30%
10%
10%
10%
I know this is getting complicated, any tips would be greatly appreciated!
Please Login or Register to view this content.
Thanks mate, that is fantastic!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks