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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.