For same item number, identify difference in item description for different location

Hi everyone

I will be grateful for any assistance here

here is an example for above question (pl check attachment if below not clear)

ITEM No. ITEM DESC. LOCATION

1000 RED_medium 10
1000 RED_med 20

I would like to know how I can identify when this happens.

THANKS

Ajmal

You mean this array formula

Formula:

Please Login or Register  to view this content.