98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Extract the unique values from a list
Extract the unique values from a list
Resolved · Low Priority · Version 2007
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
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@stl-training.co.uk
Thanks
Stephen
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Navigate with keyboard without losing your active cellIf you like using your keyboard to scroll through your excel document, but want to keep your active cell the same, use the scroll lock, and then use your arrow keys to navigate around the document. |
