Excel vba excel code to rearrange a array

[mikkeldv]

Hi,



I have an array – myArray that contains a series of strings:

05-45125

05-45125

06-45125

06-45125

06-45125

07-45125

07-45125

07-45125

08-45125

08-45125

08-45125

09-45125

09-45125



Does anyone know how to delete similar entities so a new array is formed containing the values:



05-45125

06-45125

07-45125

08-45125

09-45125



Thanks, mikkeldv

 

[BluAngelEyes23]

There wouldn't be a chance you could use something else besides Excell VBA by chance is there? If so, send me a PM.

Regards,

 

[mikkeldv]

…not really. The array is a part of a larger program where a lot of numbers are extracted, then sorted and finally reduced to contain only one of each entity. I’v tried to with different mixes of FOR and IF statements, but I can’t seem to get it to work properly. If you have got a suggestion, it would be most appreciated.

Thanks in advance.

-sorry. I do not know what a PM is?