Hi Guys,
I have a sheet that has 6 colums that get there data from list, i would like to be able to see where there are two rows with exactly the same data doesnt matter what order.
The colums are
Device Port Device Port Device Port Device Port
Each Device colum gets is list from the same list and ports come from a different list.
What i would like to be able to achieve is a list of devices with where they are attched two however i dont want to duplicate data
so it may look look
devicea 22 deviceb 21 devicec 23 decived 24
deviced 24 devicec 23 deviceb 21 decivea 22
would highlight the second one only
currently using
=AND(COUNTIF($A$2:$A$26,$A2)>=2,COUNTIF($A2:$A$26,$A2)<>COUNTIF($A$2:$A$26,$A2),COUNTIF($B$2:$B$26,$B2)>=2,COUNTIF($B2:$B$26,$B2)<>COUNTIF($B$2:$B$26,$B2),COUNTIF($D$2:$D$26,$D2)>=2,COUNTIF($D2:$D$26,$D2)<>COUNTIF($D$2:$D$26,$D2),COUNTIF($E$2:$E$26,$E2)>=2,COUNTIF($E2:$E$26,$E2)<>COUNTIF($E$2:$E$26,$E2))
Anyhelp on thi swould be good
Bookmarks