Function that will pull the unique values out of a column?

[Rgaherty]

Hi, I was wondering of there was a way to take all the unique values out of a range of data and input them into another range.

For example I'll have a list of 1-2000 in one column which can have up to 11 different values in it. These will not be numerical values mind you just 1-11 different words. What I need to do is have another column just populated by the unique values so that I can draw off that for other formulas in the sheet. I just want it to autopopulate when the user puts in their raw data.

[mikerickson]

AdvancedFilter has both "unique only" and "copy to other location" options.

[Rgaherty]

Yea but that doesnt update when new information is put into the sheet, it just remains whatever it was before. At least from my testing that's what happened.

[Reafidy]

How about putting advanced filter code into a worksheet change event so every time the raw data in column a is updated advanced filter will filter unique values to column b.

Please Login or Register  to view this content.

[Rgaherty]

Ok, assuming the data i want filtered is in cells F5:F2005 and I want the output to start at F:2008 would this be the proper format for the code?

Please Login or Register  to view this content.

[Reafidy]

Looks okay to me what happened when you tried it?

[Rgaherty]

Nevermind, I seem to have it working now, thank you very much for the assistance