This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 85%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
query excel
Need help calculating in QUERY.
I want to calculate a column that will give me a planned production quantity for the shift.
I have the possible/maximum output in each shift. And I have total demand.
The goal is to split the demand into shifts.. possible between 1-3 shifts.
(In Excel the calculation simply activates a reduction).
Thanks
Sefi
Can you give an example datasheet or screenshot and desired result?
I added example
thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 99%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Excel 365
Distribute work sequentially over 3 shifts.
One formula.
https://www.mediafire.com/file/jpnad4azcs56ha2/11_28_22.xlsx/file
thanks a lot
i will check it as part of the query.
Hi,
If the reply of HerbertSeidenberg-6295 is helpful, I suggest you mark it as answer. Other partners who read the forums with the same issue can get more information from the correct result.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Request to calculate/Compare data in 2 different row/
Hi,
Did the query is a table?
What are the conditions for calculation Production plan column?
THANKS
I Would like to know I can i calculate a value in a col at one row from data in other row.
i did it it in a very slow way in a side table with a few steps. (all the relevant data for calculate/subtruct at the same row)
How did you calculate the Column Production plan?