I seem to have misread your question. Please disregard my previous post.
--
tj


"tjtjjtjt" wrote:

Without knowing more about your data (are there other columns besides C and D
to worry about, for instance), I would do this: Instead of deleting the
duplicates, I would extract the unique values.

Click a cell in your data. In the Data menu, point to Filter and click
Advanced Filter. If you clicked in the data first, the List Range should be
filled in already. Click the Copy to another location Option button and
select the Unique records only check box.
Click a cell to start in-- I used I1-- and click OK. Excel will extract
only the unique combinations.

--
tj


"deathswan" wrote:


Hello. I have 2 columns order_no and item_no. Duplicates are allowed in
each column separately, however I would like to remove all duplicate
"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. The 2 columns are right next to each
other (order_no is column C, item_no is column D).

Thanks!
[kyle]


--
deathswan
------------------------------------------------------------------------
deathswan's Profile: http://www.excelforum.com/member.php...o&userid=33060
View this thread: http://www.excelforum.com/showthread...hreadid=528765