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