Excel, pair 2 columns, then find all rows where column J is in two different Column D

SO I would like to have a formula or macro, to look at a table in Excel, pair two columns say J and M. Then find rows where M is connected to more then one value of Column J, Column J is Super Group, Column M is group. So i need to find where a group is in more then one super group.

• Give us an example. – Gary's Student Jul 7 '15 at 15:32
• Column M has numbers, Column J has numbers column M has numbers column C is Item number. Look for rows where value of M is in row where column J is not = Column J of prior row column M is in. – 360YachtSWFL Jul 7 '15 at 19:41

1 Answer

Past the following into any column in row 2 then copy to the entire range.

``````=IF(COUNTIFS(M:M,M2,J:J,"<>J2")>0,"This group is also in another super group","").
``````

It looks if the group listed on this row is listed in another row (any row in column M = M2) with a different super group (where column J is not = to J2).

• Was this a satisfied answer? If yes, please mark as accepted. Otherwise, please edit your question to describe what’s not working. – User15 Jul 22 '15 at 19:41