software

Excel currently does not have a formula to find unique values in a range. I
have needed to do this a number of times to provide useful analysis of data
sets. There is a way to find unique values by nesting several other
functions, however it is cumbersome to use and even more difficult to edit
correctly. Since the capability exists in a round about way, it should be
easy to craft into a stand alone function.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...et.f unctions

Hi Barrett: Look at the following site

www.cpearson.com/excel/duplic...tractingUnique

Regards
Phil

quot;Barrett at Tyndalequot; wrote:

gt; Excel currently does not have a formula to find unique values in a range. I
gt; have needed to do this a number of times to provide useful analysis of data
gt; sets. There is a way to find unique values by nesting several other
gt; functions, however it is cumbersome to use and even more difficult to edit
gt; correctly. Since the capability exists in a round about way, it should be
gt; easy to craft into a stand alone function.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...et.f unctions