I have a data set of schedule activities that I have dumped into excel grouped by total days of float. I want to be able to group and total by custom amounts:
<0 days
0-10 days
11-20 days
21-50 days
>50 days
Is this possible? Doesn't have to be in a pivot table, but it can be.
Perhaps this will be of some help.
Column A is populated with dates.
Column B is populated with activities.
Columns E and F have numbers of days (from today) broken down into start and end.
Column G counts the number of activities in the time period using: =SUMPRODUCT(--(A$2:A$95-TODAY()<=F2))-SUM(G$1:G1)
Column H displays the last date of the time period (may be moved and/or hidden for aesthetic purposes) using: =TODAY()+F2
Columns I:AY display the activities in the time period using*:Formula:
Please Login or Register to view this content.
*Denotes an array entered formula with is confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
If this isn't what you envision, please upload a sample showing raw data and the expected outcome, manually typed in, so that we may attempt to automate the outcome using formulas and/or code.
To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks