How to find the duplicates by the descriptions?

[gemi]

Hai Every one.This is my first Question.I want to find the duplicate items from the dump(30000 items).I used to find by the part number matching.But some item's part number may not available in the part number column and that may be given inside the description like given below.
[TABLE="width: 715"]
<TBODY>[TR]
[TD]S.no[/TD]
[TD]Material number[/TD]
[TD]Description[/TD]
[TD]Part number[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]700303[/TD]
[TD]Nut,Size:1" UNC, For Control Valve of Fuel pipe line,Make:West Inc,Part number:5065732-32A1[/TD]
[TD]5065732-32A1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD].[/TD]
[TD]…[/TD]
[TD][/TD]
[/TR]
[TR]
[TD].[/TD]
[TD].[/TD]
[TD]…[/TD]
[TD][/TD]
[/TR]
[TR]
[TD].[/TD]
[TD].[/TD]
[TD]..[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1203[/TD]
[TD]705507[/TD]
[TD]Nut,Size:1IN UNC, Make:West Inc,P/N:50#65732-32A1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD].[/TD]
[TD].[/TD]
[TD]…[/TD]
[TD][/TD]
[/TR]
[TR]
[TD].[/TD]
[TD].[/TD]
[TD]…[/TD]
[TD][/TD]
[/TR]
[TR]
[TD].[/TD]
[TD].[/TD]
[TD]…[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]29001[/TD]
[TD]705588[/TD]
[TD]Circuit breaker,3 pole p/n:10203421-587[/TD]
[TD][/TD]
[/TR]
[TR]
[TD].[/TD]
[TD]705589[/TD]
[TD]O-ring,1" ID,2" OD,make:john crane[/TD]
[TD][/TD]
[/TR]
[TR]
[TD].[/TD]
[TD].[/TD]
[TD]….[/TD]
[TD][/TD]
[/TR]
[TR]
[TD].[/TD]
[TD].[/TD]
[TD]….[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24500[/TD]
[TD]705000[/TD]
[TD]O-ring,2" OD,1" ID used in Pump,Location:RO Plant[/TD]
[TD][/TD]
[/TR]
[TR]
[TD].[/TD]
[TD].[/TD]
[TD]….[/TD]
[TD][/TD]
[/TR]
[TR]
[TD].[/TD]
[TD].[/TD]
[TD]….[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]In this case 700303 and 705507 items are actually duplicate but 705507 item's part number not available in the part number column and given in the description.Also # typed by mistake inside the p/n.Now Material number 700303 and 705507 are to be identified as duplicate.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]705589 and 705000 also duplicates by size.For these two items there is no part number.705589 and 705000 also to be identified as duplicates.Like this many duplicates will be there in the total list.In between the duplicate items, thousands of items there.

I am preparing manually by comparing one with other.If any one knows how to simplify this by writing macro, please help me.It will be very usefull to me.

Thanks in advance,
Gemi.[/TD]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL></COLGROUP>[/TABLE]