User Profile
MHolmes007
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: Divide as Whole Number and Allocate to Monthly Column
Hi PeterBartholomew1 Many thanks for your reply. Based on: Start Date: Feb-23 Finish Date: Apr-23 Qty: 70 Your formula has equated to 23. So that would be 23 in each of the months Feb, Mar, Apr, which is total 69. The requested value is 70, so i'm missing 1. Also, once i drag your formula across the range of months, it equates to 23 in every month, not just the selected months (Feb, Mar & Apr). Could you provide further support to assist?6.8KViews0likes6CommentsDivide as Whole Number and Allocate to Monthly Column
I have a sheet with start date, finish date and quantity, then have a formula that divides the quantity over the selected months and enters the result into the appropriate month column. What I am struggling with, is that the result should be a whole number only (cannot be decimal). So for example, Cust1, the quantity (formulated) would show 11 + 12 in the selected monthly columns, not 11.5 + 11.5. My sheet resembles the following: A B C D E F G H 1 Name Start Date Finish Date Qty Jan 23 Feb 23 Mar 23 Apr 23 2 Cust1 Jan-23 Feb-23 23 11 12 - - 3 Cust2 Feb-23 Apr-23 70 - 23 23 24 I require guidance on achieving a solution using excel formula, I cannot use VBA due to network restrictions. Thanks in advance.Solved7KViews0likes8Comments
Groups
Recent Blog Articles
No content to show