There is a list under column A
30, 45, 25, 30, 46, 45, 25, 99, 1, 1, 88, 99
I would like to sort out all numbers without duplication.
The number will be return under column B in ascending order
1, 25, 30, 45, 46, 88, 99
Does anyone have any suggestions?
Thank for any suggestions
Eric

Try this:

Enter this formula in B1:

=MIN(A:A)

Enter this formula in B2 and copy down until you get blanks:

=IF(ROWS($1:2)<=COUNT(1/FREQUENCY(A:A,A:A)),SMALL(A:A,SUMPRODUCT(COUNTIF(A :A,C$1:C1))+1),"")

--
Biff
Microsoft Excel MVP


"Eric" wrote in message
...
There is a list under column A
30, 45, 25, 30, 46, 45, 25, 99, 1, 1, 88, 99
I would like to sort out all numbers without duplication.
The number will be return under column B in ascending order
1, 25, 30, 45, 46, 88, 99
Does anyone have any suggestions?
Thank for any suggestions
Eric

Thank everyone very much for suggestions
Eric

Hi,

Filter for unique records

1. Select the column or click a cell in the range or list you want to filter.
2. On the Data menu, point to Filter, and then click Advanced Filter.
3. Do one of the following.
To filter the range or list in place, similar to using AutoFilter, click
Filter the list, in-place.
To copy the results of the filter to another location, click Copy to
another location. Then, in the Copy To box, enter a cell reference.

To select a cell, click Collapse Dialog to temporarily hide the dialog box.
Select the cell on the worksheet, and then press Expand Dialog .

4. Select the Unique records only check box.

Note Once you filter for unique values, you can copy them to another
worksheet and then archive or delete the original worksheet.

Challa Prabhu

"Eric" wrote:

There is a list under column A
30, 45, 25, 30, 46, 45, 25, 99, 1, 1, 88, 99
I would like to sort out all numbers without duplication.
The number will be return under column B in ascending order
1, 25, 30, 45, 46, 88, 99
Does anyone have any suggestions?
Thank for any suggestions
Eric

Another play to get it up ..

With source numbers running in A1 down

Put in B1:
=IF(A1="","",IF(COUNTIF(A$1:A1,A1)1,"",A1))

Put in C1:
=IF(ROWS($1:1)COUNT(B:B),"",SMALL(B:B,ROWS($1:1)) )

Select B1:C1, copy down to cover the max expected extent of source data in
col A. Hide away col B. Col C returns the required results, all neatly
bunched at the top.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
There is a list under column A
30, 45, 25, 30, 46, 45, 25, 99, 1, 1, 88, 99
I would like to sort out all numbers without duplication.
The number will be return under column B in ascending order
1, 25, 30, 45, 46, 88, 99
Does anyone have any suggestions?
Thank for any suggestions
Eric

Hello Eric,

You can use my UDF lfreq:
http://www.sulprobil.com/html/listfreq.html

Regards,
Bernd