Vb Code to split and sort data

Hello:

Please refer to attached sheet.
i have data in column B from row 2 down.
I need VB Code to split digit part as i have shown in column F and G, however will need unique numbers only in column F.
Eaxmple:
Cell B4 and B5 both have 330 so use the first from the list and hence F4 needs to 330 and G4 DOUBLE COMBO.

Let me know if any questions

Thanks

Riz

One way

Please Login or Register  to view this content.

Hi Jindon:

Thanksa lot...works
Riz

You are welcome and thanks for the rep.