find unique values in a range

[Pjam]

is there a formula that find the unique values in a range , and can return them in sequential order. for example i have bunch of percentages in column A.

2%
3%
4%
2%
7%
3%
5%
6%

Thanks

 

[T. Valko]

is there a formula that find the unique values in a range , and can return them in sequential order. for example i have bunch of percentages in column A.

2%
3%
4%
2%
7%
3%
5%
6%

Thanks

You can use the advanced filter to extract the unique values to another location then sort them in ascending order.

Or, do you want to do it with formulas?

The advanced filter would be easiest.

 

[crook_101]

Hi,

The UDF described here should start you on your way....

http://www.exceltip.com/st/Look_up_unique_values_using_VBA_in_Microsoft_Excel/527.html

REgards,
Ian