split data by day
i have an list of numbers with date
i need every 15 days to be split like the sample here !
in the first row is just 1 ocurrence but later are 2 ocurrence by day
and keep grow with 2 ocurrence by day
bydate-split.xlsx
bydate-split.xlsx
i need every 15 days to be split like the sample here !
in the first row is just 1 ocurrence but later are 2 ocurrence by day
and keep grow with 2 ocurrence by day
bydate-split.xlsx
bydate-split.xlsx
Last Comment
An other question you say
in the first row is just 1 ocurrence but later are 2 ocurrence by day
In sheet2 you have from row 3 to 12 data in double what do you mean by 1 occurrence and 2 occurences ?
If I take as an example row 3 you have
Monday, January 02, 2012 6941 Monday, January 16, 2012 1261
Are these 2 related ? Jan 2 + 15 days = Jan 17 but you have there Jan 16
Please explain.
Please be more specific
gowflow
in the first row is just 1 ocurrence but later are 2 ocurrence by day
In sheet2 you have from row 3 to 12 data in double what do you mean by 1 occurrence and 2 occurences ?
If I take as an example row 3 you have
Monday, January 02, 2012 6941 Monday, January 16, 2012 1261
Are these 2 related ? Jan 2 + 15 days = Jan 17 but you have there Jan 16
Please explain.
Please be more specific
gowflow
This takes a long time to run. Let me know if the output is the way you want it. If it isn't I'll try to make it faster.
29016517.xlsm
29016517.xlsm
Do you want 15-day periods even if they span months? In other words in February (assuming it has 28 days) do you want 2/1 to 2/15 and 2/16 to 2/28 or do you want 2/1 to 2/15 and 2/16 to 3/2?
ASKER
gowflow THnks !! for you fast response!!
YES !! I have the detail in here the very firts dates just have one ocurrence but later on are twice by day
so the firts 15 days of the those firts years are 1 ocurrence
later on beging with 2 ocurrence by day !
YES !! I have the detail in here the very firts dates just have one ocurrence but later on are twice by day
so the firts 15 days of the those firts years are 1 ocurrence
later on beging with 2 ocurrence by day !
ASKER
Martin i need it bet every 15 days but in the case of the february will be ok until 28
So we should not span on a new month or its ok ??
gowflow
gowflow
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
gowflow yes ! it have to keep going month by months through the year!!
and next year!
and next year!
Did you try my code????? (Click the button on Sheet1)
ASKER
Martin is great wotking great but i need keep the format colors in !
ASKER
yes martin im testing ! it
i need keep the format colors inIt has the colors except for the color in B4 (and other rows) which you don't have either.
ASKER
Martin !is working great ! is good to me !! Perfect !!
ASKER
gowflow is like the example martin provide to helps us !
ASKER
Martin is more faster !! Great Job !!
ASKER
gowflow the martin solution ! is working to me
if you have any other point im open to check in !
if you have any other point im open to check in !
ASKER
Great Solution !!
Thanks. I learned something too.
Sorry I was caught in other thing in between. Great you got what you need.
gowflow
gowflow
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Like you want the output as per sheet2 ?
gowflow