Find conflicts within the same commodity number

[COGICPENNY]

Hi,

I'm trying to find where a conflict occurs for a commodity.

A conflict is where for the same commodity in COLUMN E (i.e. 123456789), there is an "eliminated" value in one row, and another row for that commodity has "unchanged" in COLUMN M.

I first tried to sort and group them by commodity codes to see if I could "eyeball" any conflicts where there's both an "eliminated" and "unchanged" value, but there are over 1500 rows of data, and there's got to be an easier way. VLOOKUP only takes the first value so it's restrictive. I have attached a copy of the spreadsheet.

Thank you in advance,

Penny

[Ace_XL]

In Column N use

In N2
=AND(COUNTIFS(E:E,E2,M:M,"Unchanged"),COUNTIFS(E:E,E2,M:M,"Eliminated"))

Copy down

TRUE indicates conflict, FALSE indicates no conflict

[COGICPENNY]

THANNNNKKKK YOUUUU!! It worked perfectly! Done in 2 seconds!