Hello Everyone,
I have a worksheet with a whole bunch of locations in it (they all appear multiple times )
I would like to create a list of each location ( appearing just once ) to build a lookup table from.
Can someone help me with the quicket and easiest way to do this?
Thank you.
Last edited by todmac; 02-09-2012 at 07:19 PM.
1) Highlight the column of values
2) Activate the Data > Filter > Advanced Filter
3) Copy to another location > Unique Values only
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
todmac,
You could use AdvancedFilter Unique.
If column D had a title locations, you could highlite column D
Click on Data
Filter
Advanced Filter…
Click on the radio button Copy to another location
In the Copy to: box type in N1
where N1 is an available blank column
click on the box for Unique records only
And, click on the OK button.
There is your unique list of locations.
Have a great day,
Stan
stanleydgromjr
Windows Vista Business, Excel 2003 and 2007
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Thank you everyone.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks