formula to check correct data

[Belinda001]

Hello,

could someone please help me with following.

I need to check the file attached for following.

Kolom A = Kolom J AND kolom B = kolom K - then I want to check if the quantity in kolom C = quantity in kolom L

[AliGW]

Where are the expected results to go?

[Belinda001]

the first table is the table I need to correct.
Second table is the corrected one.
So I need to know if in the first table there are different values for the quantities. So after the first table, so I can check if that line occurs in the second table and the values are same/different.

[AliGW]

Sorry - that's not what I asked! Where should the check appear?

[Belinda001]

kolom I - after the first table

[AliGW]

Try this:

=IF(COUNTIFS($J$4:$J$1132,[@[Item No.]],$K$4:$K$1132,[@Code],$L$4:$L$1132,[@[Qty. per Unit of Measure]])=0,"No","Yes")

Or, for your locale:

=IF(COUNTIFS($J$4:$J$1132;[@[Item No.]];$K$4:$K$1132;[@Code];$L$4:$L$1132;[@[Qty. per Unit of Measure]])=0;"No";"Yes")

If this isn't it, then you need to show us what you want.

[torachan]

Looping macro on green button - if all equal row number of table shown in column 'I'
if gap most likely quantities are different.
torachan.