I have the following issue:

Average store
cat 1 is 47.1% or 21 pair
cat 2 is 24.2% or 11 pair
cat 3 is 17.2% or 8 pair
cat 4 is 11.5% or 5 pair

Total pair is 45 or 100% of the display.


AA Store is 10% less in cat 1 and 2, & 10% better in cat 3 and 4.
A Store is 20% less in cat 1 and 2, & 20% better in cat 3 and 4.
B Store is 30% less in cat 1 and 2, & 30% better in cat 3 and 4.


What is the formulas to redistribute the pairs amongs the AA, A, and B
stores for each category. The new redistrution must obviously equal
45.........

Thank in advance for the assistance.


--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=572387