Have you tried data/filter/advanced with unique values?

"norumbegan" wrote:

>
> Hi,
>
> I have several columns of numbers in no particular order. I want to
> arrange them in ascending order, but eliminate all values that are
> repeated. For example, if the original column looks like this:
> 1 - 4.1
> 2 - 1.5
> 3 - 5.9
> 4 - 5.9
> 5 - (blank)
> 6 - 4.1
> 7 - 1.5
> 8 - (blank)
> 9 - (blank)
> 10 - 4.1
>
> I want the final column to look like this:
> 1 - 1.5
> 2 - 4.1
> 3 - 5.9
>
>
> The values and number of repeats vary in each column, so I need a
> solution that takes this into account.
>
> On a related note, is there a way to return the max or min of a list,
> such that it's below a specific value?
>
> Thanks,
> norumbegan
>
>
> --
> norumbegan
> ------------------------------------------------------------------------
> norumbegan's Profile: http://www.excelforum.com/member.php...o&userid=37495
> View this thread: http://www.excelforum.com/showthread...hreadid=571497
>
>