evenly distribute numbers across a range
Column D represents an even spread value-to-value, but an even spread in time.
In addition to the formulas I posted, In E1 enter:
=RAND() and copy down thru E12
In F1 enter:
=INDEX($D$1:$D$12,RANK(E1,$E$1:$E$12))
and copy down thru F12
Column F should be what you need. It takes column D and "randomizes" it
over the 12 months
--
Gary''s Student - gsnu2007k
" wrote:
The result I got was seven 1s in cells D1-D7. I'm trying to get seven
1s distributed as evenly as possible across cells D1-D12.
I really appreciate you taking the time to help!
|