Hi Sana,
So if this is your sample data:
Buyer's Purchase order balance Seller's order balance
Items Quantity (balance) Items Quantity (balance)
A010 100 A010 100
B020 225 B020 225
C02V 320 C02V 32
F0320 600 CC020 156
RTO10 200 RTO10 200
EFGTL 65 EFGTL 23
BCVB 45
Then how do you foresee the result to look like?
Something like this?:
Buyer's Purchase order balance Seller's order balance
Items Quantity (balance) Items Quantity (balance)
A010 100 A010 100
B020 225 B020 225
C02V 320
C02V 32
F0320 600
CC020 156
RTO10 200 RTO10 200
EFGTL 65
EFGTL 23
BCVB 45
So basically compare column A & B with C & D and if there is a difference, create a new row to split the data from 1 row to 2 rows.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Here is the sample data. It is about the purchase order's balance quantity. We are buyer and we give purchase order to seller. We import different quantity of different items and record our balance order quantity. Our seller also record the balance quantity and send us to match these with those we have recorded. So as the list is too big i want here the following things.
1- Match both buyer's Purchase order items and quantity with seller's items and quantity.
2- If there is any unique values, want to know which are not in buyers so that i add those in buyers list.
3-Which items and quantity are in buyers list but not in sellers so that i inform them to add in your (seller ) list.
As the list is too big i want some shortcuts in the form of formula to save my time.
Buyer's Purchase order balance Seller's order balance
Items Quantity (balance) Items Quantity (balance)
A010 100 A010 100
B020 225 B020 225
C02V 320 C02V 32
F0320 600 CC020 156
RTO10 200 RTO10 200
EFGTL 65 EFGTL 23
BCVB 45
Hope this help.
Thanks.