moccasinus
New Member
- Joined
- Aug 8, 2017
- Messages
- 30
- Office Version
- 365
- Platform
- Windows
Hi, is there a way, without using Pivot, to return a specific sum through duplicate list entries, example:
<tbody>
</tbody>
I only need the sum of 100 taken from 'Total qty needed' and returned in 'Qty needed' column based on corresponding values in column 'Qty'.
I imagine if there is a formula it should return such values:
<tbody>
</tbody>
Btw, the list I want to do this for is several thousand rows, would be great to avoid array formula.
Anyone knows what could be the formula for this? Thanks in advance
Item | Qty | Qty needed | Total qty needed | ||
Item#1 | 1 | = | 100 | ||
Item#1 | 200 | = | |||
Item#1 | 50 | = | |||
Item#1 | 500 | = |
<tbody>
</tbody>
I only need the sum of 100 taken from 'Total qty needed' and returned in 'Qty needed' column based on corresponding values in column 'Qty'.
I imagine if there is a formula it should return such values:
Item | Qty | Qty needed | Total qty needed | ||
Item#1 | 1 | 1 | 100 | ||
Item#1 | 200 | 99 | |||
Item#1 | 50 | 0 | |||
Item#1 | 500 | 0 |
<tbody>
</tbody>
Btw, the list I want to do this for is several thousand rows, would be great to avoid array formula.
Anyone knows what could be the formula for this? Thanks in advance