0

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.

2
  • Give us an example. Jul 7, 2015 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. Jul 7, 2015 at 19:41

1 Answer 1

0

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).

1
  • 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, 2015 at 19:41

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .