haw to remove duplicates from an array

[dmcgov]

i have been googling the above and have not found a solution to my needs. all i need is to remove duplicates from an array. i searched this site but did not find a solution in the first few pages. here is my code:

Please Login or Register  to view this content.

and here is the functions that i am using:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

so when i print out the MyNames(0), it is a list of names that is 11 words long, and it contains multiple names. i thought that when i used the function "IsInArray" that that would prevent the duplicates from occurring but it doesn't. and when i use the removedupes function, it doesn't do anything. im sure that this is because i am making an error in my code. could someone point out to what i have done wrong?

[Fluff13]

Why not just use a Scripting.Dictionary?

[dmcgov]

one of the functions does just that, see below:

Please Login or Register  to view this content.

still working on this, might have an answer in a bit.

[Fluff13]

I was thinking more of using the dictionary in the original code, rather than in a function.
Also that is not one of the functions you originally posted.

[dmcgov]

i have tried several functions, but it might be how i assemble the array that is causing the problem. give me a bit to experiment and i will post back my results.

[Fluff13]

With the Function in post#3 try

Please Login or Register  to view this content.

[dmcgov]

i have tried several functions and procedures to make this work but i still can't figure out what i am doing wrong.

i have data in cells A3:14 to D3:D14. i need create a list or array that uses unique names (in col A) based on code in col C.

so my range("A33") should contain 4 names (and not 11) that have text wrap enabled and are listed one line at a time (but all in once cell).

Fluff, can you assist?

[Fluff13]

Can you supply a sample workbook, showing expected results.

[dmcgov]

here is the workbook. note that i am helping out user on this thread: https://www.excelforum.com/excel-pro...ml#post5157048

the procedure named testsumifs3 is what created most of the data (rows 33 - 37). just need names to be in column A. also note that my arrays (myarray, myarray2, myarray3) needs to be dynamic. any help is great!

[Fluff13]

Thanks for that, I have replied direct to the other thread, as I was struggling to understand some of what you were doing.

[dmcgov]

can i ask you what i was doing wrong in trying to get the names in to column A?

in particular, is the function isinarray. i thought that if it was false, it was safe to add to array but it doesn't work like i would have expected.

[Fluff13]

I'm assuming that you were trying to do that with this bit of code

Please Login or Register  to view this content.

and whilst I don't quite understand what you were doing, the part in blue will just add the same name into each element of the myNames array as the value in names(a) does not change during that inner loop

[dmcgov]

i guess my question is on this bit of code:

Please Login or Register  to view this content.

my understanding is that it examines the array, and if not found, then adds it. where am i going wrong?

[Fluff13]

Difficult to tell as that code does not exist in your workbook.