Return unique values from an array?

[xiano]

thanks to those of you who sent a response regarding a Concatenate/String problem. Basically, the file got to something like 30MB with just half of the formulae created(!!), so I had to ditch that route.

I'm writing a macro; it contains a simple array with 17 items, all dates. From this, I need to get a list of the unique values from the 17 (probably assigning them to a dynamic array).

How can I return unique values from the array, so if there are 5 unique dates in the 17 items, i can populate an array with these 5?

Apologies for being myopic here - I'm sure this is straighforward but I can't work it out!

thanks

christian

 

[SteveO59L]

Have you looked at using a Pivot Table with your data ?

 

[xiano]

actually, no - I've never really dealt with Pivot Tables, so am unaware of their functionality.

How would this help?