Excel formula, remove QTY , from another sheet

I have two Sheets.

Sheet 1 name is 01.09.2017. 
Sheet 2 name is rest


In sheet 1 i have 3 columns


name   QTY     price    together
asd          2      1000      2000   

in rest i have 2 columns

name   QTY
asd        50

i want to remove from rest QTY as many QTY as are in sheet 1. How can i write the formula ?

By: tigran

Leave a Reply

Your email address will not be published. Required fields are marked *