building and comparing a string to an array

[dcharland]

Hi,

I'm not event certain that i'm using the appropriated terminology? But I will try to explain in details what i'm trying to do.

I have a string "email.email.com" and a "status" variable that I would like to include to an array, then if it's not the first email within this array.
compare it to the ones already in the array.
If it exist, don't include it in the array.
if it not already in the array, then include it.

So in the end I would have within a array something that looks like

email1 status (note status is a string variable like "read" "not read")
eamil2 status
ect.

Thanks in advance for any guidance you can provide.

 

[Blade Hunter]

I think you are trying to get a distinct list.

If so I would rather than polling arrays (which can be time consuming) read out the list to a sheet then use the advanced filter to copy to another destination removing duplicates then read the resulting column in to your array.

Cheers

Dan

 

[dcharland]

Thanks for the response, I will give it a try