How to find duplicated items???

[VN]

I would like to find items that may duplicate in my data.

My data have dimension WxLxH or LxWxH or HxWxL so I have to do some thing to separate the item that may be duplicated item.

How can I do?

(may be make a format color for duplicated items)

Exsample as below;

Book1
	C	D	E	F	G
17	Original Data				New Data
18	12x5x6 mm.				12x5x6 mm.
19	3*2*5.5 mm				3*2*5.5 mm
20	5mm x 77.3 x 8mm				5mm x 77.3 x 8mm
21	3 mm x 2mm x 5.5 mm	I would like it to be==>			3 mm x 2mm x 5.5 mm
22	12mm*5mm*6mm				6mm*12mm*5mm
23	12x5x6 mm.				5x6 x12mm.
24	3*2*5.5 mm				3*2*5.5 mm
25	5mm x 77.3 x 8mm				5mm x 77.3 x 8mm
26	4 mm x 2mm x 5.5 mm				4 mm x 2mm x 5.5 mm
27	12mm*5mm*6mm				12mm*5mm*6mm
28	12x5x6 mm.				12x5x6 mm.
29	3*2*5.5 mm				3*5.5*2 mm
30	5mm x 77.3 x 8mm				5mm x 77.3 x 8mm
31	5 mm x 2mm x 5.5 mm				5 mm x 2mm x 5.5 mm
32	12mm*5mm*6mm				12mm*5mm*6mm
Sheet1

 

[VN]

Hi, Tony.
Your lastest code work perfect . Thank you for your kind support my problem . I hope that I will recieve some advice from you in the future. Thanks alot Tony.

VN.


Hi, Agihcam
I 'm not run your code yet. I will try it.However , Thank you for your advice.

VN

 

[VN]

Hi,

If I would like to add other sign to this code . How can I do ?

I mean that If I have another sign in my data ( in the futer) such as - or / ..etc…


Thank you.

 

[acw]

Hi

Change the 2 lines

fs.Pattern = "[^0-9*x.]"

fs.Pattern = "[x*]"


The first one is to show the characters you want to keep, and the second is for the characters you want to convert to "x"


Tony

 

[VN]

Hi
Thank you so much , Tony
I got it.