Excel Made Easy

Generate a list of unique values in Excel

Hello again,

I need to generate a new list of data taken from an existing list of data and then put this list in a new worksheet... but the trouble is that this existing list (call it 'list A') has many repeating values which I do not want in the new list (call this 'list B'). Normally I'd forgo the hassle of fiddling with macros for this but I need this to be a dynamic list so that the user can update list A and then list B will automatically correct itself without the user having to do it themselves.

For example:

List A

Monkey
Monkey
Turnip
Dinosaur
Dinosaur
Dinosaur
Wallaby
Pirate

List B

Monkey
Turnip
Dinosaur
Wallaby
Pirate

I'm sure that this is very easy to do but I just cannae think how to do it!

Any help or ideas would be greatly appreciated. 

James

Answer:

To generate a list of unique values, use the advance filter option that allows you to remove the duplicate.

You can find similar Excel Questions and Answer hereunder

1) How can I list all files in a folder using VBA?

2) How do I get the rank of a number in a list of numbers?

3) Applying a countif formula only to visible cells in a filtered list in Excel

4) How can I set up a drop down list?

5) Vlookup to return multiple values in same cell in Excel

6) Remove the apostrophe cell text values in Excel

7) How can I have text autocomplete based on values previously entered in Column?

8) How do I restrict user entry in ActiveX Text Box to just numeric values?

9) I work with a SW that returns Hex values - how can I convert them to decimal values?

10) Here an explanation about list box and how to control list boxes in Excel VBA