Hi, is there a way, without using Pivot, to return a specific sum through duplicate list entries, example:
<tbody>
Item
Qty
Qty needed
Total qty needed
Item#1
1
=
100
Item#1
200
=
Item#1
50
=
Item#1
500
=
</tbody>
I only need the sum of 100 taken from...