Filtered list into an array

[Macro1]

Hi,

I have a full list of data with the first column being the user, what I want to try and do is filter this list based on the computer user parameter, and pass the filtered list into an array.

At the moment coloumn 1 in the array is passing through like so:

Bob
Tom
Lucy
Bob
Steve
Bob

What I wanted is for it to look like this:

Bob
Bob
Bob

The code I have so far is:

Please Login or Register  to view this content.

Any help would be much appreciated.

Thanks in advance

Macro1