View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gor_yee Gor_yee is offline
external usenet poster
 
Posts: 38
Default 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