Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Extract the unique values from a list

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Extract the unique values from a list

Resolved · Low Priority · Version 2007

Reply Fri 25 Feb 2011, 09:16Delegate Kelly said...

Kelly has attended:
Excel VBA Intro Intermediate course

Extract the unique values from a list

Hi.

I have a long list with many duplicate items in it and I would like to pull from this a list of the unique values, onto a seperate tab, so as to use it in a loop. How would I go about this using vba?

Thanks

For upcoming training course dates see: Pricing & availability

Reply Mon 7 Mar 2011, 16:55Trainer Stephen said...

RE: Extract the unique values from a list

Hi Kelly

Thanks for your question

Could you perhaps send me a sample of the type of worksheet that you want to work with, and then I can write the code to accomplish this

My email is sw

Thanks
Stephen

Excel articles

· Tell AutoFill What To Do And It Will Oblige
· Find Out Your Age In Days With Excel
· Experience The Power Of PowerPivot
· Baffled by custom number formatting in Excel?
· Securing Critical Company Information With Simple Visual Basic Training Courses

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips