Hello. I have 2 columns order_no and item_no. Duplicates are allowed i
each column separately, however I would like to remove all duplicat
"pairs" of order_no and item_no. So for instance (order_no, item_no) -
[(1, 4) and (1, 4)] would be deleted, but [(1, 3) and (1, 4)] OR [(1, 3
and (2, 3)] would be be allowed. Basically my primary key is th
superkey of both order_no and item_no which is why I can't hav
duplicates. The 2 columns are right next to each other (order_no i
column C, item_no is column D).

Thanks!
[kyle

--
deathswa
-----------------------------------------------------------------------
deathswan's Profile: http://www.excelforum.com/member.php...fo&userid=3306
View this thread: http://www.excelforum.com/showthread.php?threadid=52873