Excel - Macro|group by|based on time interval
Closed
vreexs
Posts
2
Registration date
Friday June 3, 2011
Status
Member
Last seen
June 3, 2011
-
Jun 3, 2011 at 11:10 AM
vreexs Posts 2 Registration date Friday June 3, 2011 Status Member Last seen June 3, 2011 - Jun 3, 2011 at 01:50 PM
vreexs Posts 2 Registration date Friday June 3, 2011 Status Member Last seen June 3, 2011 - Jun 3, 2011 at 01:50 PM
Related:
- Excel - Macro|group by|based on time interval
- Popcorn time download - Download - Movies, series and TV
- Ocarina of time rom - Download - Action and adventure
- Excel macro to create new sheet based on value in cells - Guide
- Spell number in excel without macro - Guide
- Whatsapp time setting - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 3, 2011 at 11:15 AM
Jun 3, 2011 at 11:15 AM
Based on your sample data, what would be the output ?
Since it is hard to see the columns, could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://accounts.google.com/ServiceLogin?passive=1209600&continue=https://docs.google.com/&followup=https://docs.google.com/&emr=1 http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like
Since it is hard to see the columns, could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://accounts.google.com/ServiceLogin?passive=1209600&continue=https://docs.google.com/&followup=https://docs.google.com/&emr=1 http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like
vreexs
Posts
2
Registration date
Friday June 3, 2011
Status
Member
Last seen
June 3, 2011
Jun 3, 2011 at 01:50 PM
Jun 3, 2011 at 01:50 PM
Hi rizvisa1,
thanks for the prompt response. my appologize for not describing my problem clearly. the sample excel file is in the following URL.
https://spreadsheets2.google.com/spreadsheet/pub?key=0Au5fnTRIShgudFFQN2Rka3R0dnBGRkJnSHllRk5zQVE&output=html
The sample data is in "sample input data" sheet. it does not have any macro nor formula and the output i foresee is in "expected outcome" sheet.
if you see the column name in the "sample input data" sheet, basically the solution is to count how many project for each month and for each category (valued 1, 2 and 3) split to base, planned and actual.
hope this would make it more clear and thank you
rgds,
[vf]
thanks for the prompt response. my appologize for not describing my problem clearly. the sample excel file is in the following URL.
https://spreadsheets2.google.com/spreadsheet/pub?key=0Au5fnTRIShgudFFQN2Rka3R0dnBGRkJnSHllRk5zQVE&output=html
The sample data is in "sample input data" sheet. it does not have any macro nor formula and the output i foresee is in "expected outcome" sheet.
if you see the column name in the "sample input data" sheet, basically the solution is to count how many project for each month and for each category (valued 1, 2 and 3) split to base, planned and actual.
hope this would make it more clear and thank you
rgds,
[vf]
