Hi All , I am new to this forum and seeking your help on a problem,
I need to calculate the demand intervals for a forecasting sheet , so I have multiple demands and I need to calculate the period between the demands
Demands Intervals
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Demands 0 1 0 11 0 0 0 0 2 0 6 3 0 2 0 2 0 0 0 0 5 0
Hello fabian_andrew and Welcome to Excel Forum.
I have set up a spreadsheet based on my understanding of the layout of your data.
It may speed up the process if you will input the expected results and then attach the spreadsheet to a reply by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling 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.
Hi JeteMc , Thank you for your response , yes your understanding is correct , I want to get the number of intervals 0 occurs plus the current which is greater that 0 , I am attaching the file with the expected output highlighted
in yellowCapture.PNG
fabian_andrew you attached a picture of your file, not the file itself. Pics are pretty much impossible to edit, so you need to share your (cleaned) file with us
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi , I have attached the file now , I have highlighted what out put I am looking for in yellow , I want to get the same for all the rows
This proposed solution employs a helper row, in columns AA:AL, for each part number.
The formula that populates the helper rows is: =IF(A2=0,Z2+1,1)
The formula that populates the table (yellow) is: =IF(B2=0,0,AA2)
Let us know if you have any questions.
Another way. Try array entering this in N2 and filling down and across. If you arent familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Formula:
Please Login or Register to view this content.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks