VN
Board Regular
- Joined
- Aug 19, 2003
- Messages
- 83
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;
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 |