Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 27th 15, 06:55 AM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1
Default Spreading number evenly over 165 days

I need an Excel file which can sort a given number (22) evenly across the days of a year (165) without decimals (so they need to be rounded), so that I can see how often it appears within the year.

But the number 22 stands for 22 events. And there are multiple sets of those 22 events. I do not want the first event of each set to coincide with the date of the year which is my starting point—I want the 12th event to coincide with it so that I can see how many days are between each 12th event of a set and the 12th event of the previous set, when they are evenly spaced as stated before.

  #2   Report Post  
Old April 29th 15, 11:15 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 1,522
Default Spreading number evenly over 165 days

On Monday, April 27, 2015 at 1:49:05 AM UTC-5, LightningEclipse wrote:
I need an Excel file which can sort a given number (22) evenly across
the days of a year (165) without decimals (so they need to be rounded),
so that I can see how often it appears within the year.

But the number 22 stands for 22 events. And there are multiple sets of
those 22 events. I do not want the first event of each set to coincide
with the date of the year which is my starting point—I want the
12th event to coincide with it so that I can see how many days are
between each 12th event of a set and the 12th event of the previous set,
when they are evenly spaced as stated before.




--
LightningEclipse


Doesn't make any sense


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreading date range across days in weeks (advanced) StephenT Excel Discussion (Misc queries) 7 February 19th 10 03:28 PM
dividing a number up evenly into a year jxbeeman Excel Discussion (Misc queries) 3 June 10th 09 04:17 PM
Distributing a number evenly over several set priority's. rvaughnp Excel Discussion (Misc queries) 5 April 14th 09 01:13 AM
Excel Spreading dates evenly in a row of cells OHNESORGE Excel Discussion (Misc queries) 2 March 12th 09 02:26 PM
Spreading 1 large number evenly into several cells Dos Equis Excel Worksheet Functions 0 October 4th 06 05:50 PM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017