跨行Excel扩展值 [英] Spread values across rows Excel

问题描述

我有两张表（一份用于采购订单，另一份用于发票），我想将数量从发票表分发到采购订单发票数量列，但是我想与采购订单数量中的确切数量相匹配。

以下是表格如何查看

这是我想要的样子：

我该怎么做？谢谢！

这是excel附件文件：

解决方案

E2单元格中的强>发票数量和M2单元格中的数量，将此公式放入E3中，

  = MAX（MIN（M $ 3-SUM（E $ 2：E2），D3），0）
  

根据需要填写

I have two tables (one for purchase order and the other for the invoice) and I want to distribute the quantity from the invoice table to the purchase order invoice quantity column but I want to match the exact quantity from the purchase order quantity.

Here is how the table looks now

And this is how I want it to look:

How do I manage to do that? Thanks!

Here is the excel attachment file: Book1.xlsx

Update: Is it possible to do that for multiple codes?

解决方案

With Invoice Quantity in the E2 cell and and Qty in the M2 cell, put this formula into E3,

=MAX(MIN(M$3-SUM(E$2:E2), D3), 0)

Fill down as necessary.

        

这篇关于跨行Excel扩展值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！