Forumlas or scripts?
 

I've got a problem...I've got some profiles for 7 days worth of trading
that equal to 100%. For example, I've got an area profile that is
Mon-9.49%, Tue-9.13%, wed-11.95%, Thu-18.15%, Fri-17.96, Sat-21.94%,
11.39%.

Ok..now i've got about 200 profiles under this area..but they are all
over the place like a 50% for Sat (So which is not right)...is there
anything that excel can do to re jiggle the profiles to be with 2%
variance of each day's profile?So instead of me changing it one by
one..is there a fast way?Help really really really needed. THanks