True False Condintion / Excel

[Sirfyaad]

I know that this question of mine is not related to you, but I hope that you will definitely help me.

I have duplicate keys in the key columns of my sheet. But the product is unique. I want that if the data key and product are equal, then as much as they have been given qty, they should be allowed, otherwise they should show false.

please share exmpla formulas.

[Joseph_Seddik]

If you have duplicate keys, then AppSheet will see only one row among the duplicates. The other rows having the same key will be ignored and will not processed in anyway by your app. There’s no workaround for that, you have to add a separate key column with truly-unique values to your tables.

[Sirfyaad]

im talking about excel exprestion not appsheet.