Find what is left

[Pierre]

Hello,

I have a list of boxes with the products inside. Physically I have a control where a person scan the box, input the product and qty to check if something is missing.

I would like to add in a separate sheet the remaining products of the box that are currently in processing (see example in enclosed file) using a formula.

Thanks in advance for help

 

[bosco_yip]

Hi,

1] Formula solution with 3 concatenate helper columns

2] Please see attached file.

p.s. I changed H4 from 50 to 45 in order to keep some remaining qty for testing purpose.

Regards
Bosco

 

[Pierre]

Hello bosco_yip,

It's exactly what I needed, thanks a lot

 

[Pierre]

I try to use the formula on a bigger database and with data on different tabs, but I encounter some problems...
Could you have a look pls?

 

[bosco_yip]

I try to use the formula on a bigger database and with data on different tabs, but I encounter some problems...
Could you have a look pls?

Please see revised file and the formulas are fixed.

Regards
Bosco

 

[Pierre]

Thanks a lot Bosco It was of great help!