View Single Post
  #4   Report Post  
Old December 23rd 08, 02:59 PM posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default 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!