Excel Forumula Help

[michael_allen_24]

I have a list of names such as:

1. Kay
2. Roy
3. Jay
4. Kay
5. Pete
6. Roy
7. Kay
8. Tom

These names might be repeating, such as Kay appearing 3 times above. How do I create a forumula to pull back the names in alphabetical order? But obviously omitting the repeating values? So if the forumula worked correctly I would have:

1. Jay
2. Kay
3. Pete
4. Roy
5. Tom

Thanks in advance

 

[michael_allen_24]

Unbelievable man! Thanks for all your help. Happy New Year!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[mgirvin]

Wow!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
That is simply beautiful! Formulas like that, Richard, make Excel MUCH more fun than playing videos games!

 

[mahmed1]

Wow!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
That is simply beautiful! Formulas like that, Richard, make Excel MUCH more fun than playing videos games!

Hi Mike

Try making a video on this when you are free

CHEERS

 

[mgirvin]

mahmed1,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
OK! I will try to make a video later today - that attempts to reveal the beauty of Richard’s post.

 

[Matty]

You must enjoy making those videos, Mike! I count that as two requests in just over a week from mahmed1 alone!

Matty

 

[mgirvin]

I hadn't noticed about the same Excel Enthusiast requesting two in one week. But no problem, what better way to spend vacation days than to make Excel videos!

 

[mgirvin]

mahmed1,

Here is a video:

http://www.youtube.com/watch?v=IZLAzIYfMDU

 

[Matty]

mahmed1,

Here is a video:

http://www.youtube.com/watch?v=IZLAzIYfMDU

Good work, Mike.

Matty

 

[mgirvin]

I am glad that you like it Matty!

Thanks for the formula, Richard Schollar!!

 

[Marcelo Branco]

Oh, you are the guy who has teached me how to use FREQUENCY function (i saw the video several times) and many others tricks.

Good job Mike and thanks so much.

Happy new year!

M.