Linking to a column of values, excluding duplicates?

**bauerbach** · 06-25-2012, 01:10 PM

I have a master list of products and production locations.

something like

Product 1 Atlanta
Product 2 Atlanta
Product 3 Chicago
Product 4 Dallas
Product 5 Dallas

What I need, is in a seperate worksheet, I need to pull

Atlanta
Chicago
Dallas

Hoping to do this without any intermediate steps and without needing to run a manual filter. I cannot format the source list.

Is there any way to pull a list of discrete values from another column?

like... a super long string of If statements, If A1<>any previous values, return that value... If A2<> any previous values, return that value. Or maybe there is a function that will return the first result of in the column that meets the criteria?

**rob.barnes01** · 06-25-2012, 01:15 PM

If a VBA solution is acceptable, maybe this will fit your needs:

Please Login or Register  to view this content.

Hope this helps.

**bauerbach** · 06-25-2012, 01:18 PM

its an option. Not ideal since it requires the user to recognize the need to update the list (and knowing is half the battle

)

But I will keep that in the back pocket if no formulaic solution can exist.

**oeldere** · 06-25-2012, 01:26 PM

You only need the value below

Atlanta
Chicago
Dallas

Or you need more information?

Otherwise copy the collum of the value and paste it in another worksheet.

Then Data => remove duplicates

**martindwilson** · 06-25-2012, 01:28 PM

easy with a helper column,but you don't want that tho do you?
or try this
http://www.exceltip.com/st/Retrievin..._List/805.html

**bauerbach** · 06-25-2012, 02:13 PM

Originally Posted by martindwilson

easy with a helper column,but you don't want that tho do you?
or try this
http://www.exceltip.com/st/Retrievin..._List/805.html

Winner!

This looks like a functional/elegant solution to the problem! Love it.

Doesnt appear that it even needs an "empty" cell at the top either, I was able to use the column header as its starting cell without an issue.