A simple way to do this with formulas would be to do the following.
1. sort the column that has the values you are evaluating.
2. in an adjacent column, set the first cell (even with the top value
in your list) equal to 1. so if your values are in column A, put the
"1" in column B.
3. below the "1" cell, (in this case B2) enter the formula
=IF(A2=A1,"x",1)
4. this will give you a list with lots of x and 1s. apply an
autofilter to this list and filter out only the 1s
Let me know how this works.
--
barrfly
Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile:
http://www.excelforum.com/member.php...fo&userid=4141
View this thread:
http://www.excelforum.com/showthread...hreadid=391880