DataAutofilterAdvanced FilterUnique records only

"cj21" wrote:


Sorry about the last post, ignore it.

My problem is this:

tariff Product code
25 0118
25 0118
45 0320
45 0320
10 0460
45 0460
25 0470
45 0470
45 0481
50 0481
45 0484
45 0484


I have the above table, but product codes are duplicated. I want to get
rid of the duplicates, even if the tariff is different. Any ideas, there
are about 2000 rows .

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=396853