Return a consolidated array?

**agentsmith83** · 03-17-2010, 10:50 AM

I was wondering if anyone know of a function that will look at a range of cells containing text and return a consolidated array, which eliminates duplicate entries. For example, if have a range such as:

Apple
Apple
Apple
Banana
Banana
Orange
Orange
Orange
Orange

I would like to return the list: Apple, Banana, Orange for use in a data validation drop-down.

Thanks.

**NBVC** · 03-17-2010, 10:59 AM

Try Advanced Filter found in the DATA|FILTER menu... (make sure to check Unique Records).

**agentsmith83** · 03-17-2010, 11:14 AM

Thanks. However, I was hoping to achieve this effect by using a function which can be used for data validation. I'm trying to get a drop-down list based on unique entries from a list such as the fruit example above. Any other thoughts? Thanks again.