how do I create a new list of unique entries from a list of one with duplicates?

[AFST]

On sheet 3 in P1:P2510 I have a list of numbers which contain duplicates

On sheet 2 in C15:C31 want to reproduce the results of whats in column P just skip duplicates.

So for example:

P has 300, 305, 305, 310, 310

I would like C15 to equal 300, C16 to equal 305, C17 to equal 310 etc.

Yes I realize that there are many more cells being evaluated in column P than displayed in column C, but I don't expect there to be more than about 15 returns.

Please help!

 

[Momentman]

Except you really want to do it with formulas. if not,
1. You can copy the list to column C and use remove duplicates feature from the DATA tab and you will have what you want
2. use a pivot table to get a unique list of entries

 

[JLGWhiz]

Select the column with the data containing duplicates. On the ribbon click Data then in the Filter section click Advanced. Enter a range where you want the unique items listed and click the Unique checkbox. Click OK.

 

[AFST]

Given the setup I have, and that the information is constantly changing and would like it to be an automatic sort of thing from a formula. Is it possible?

 

[Momentman]

This is a "popular" formula you can hopefully adapt, unique values are shown in column C of my example

Excel 2010
	A	B	C
1	300		300
2	305		305
3	305		310
4	310
5	310
Sheet7

Cell Formulas
Range	Formula
C1	{=IFERROR(INDEX($A$1:$A$5,SMALL(IF(FREQUENCY(MATCH($A$1:$A$5,$A$1:$A$5,0),ROW($A$1:$A$5)-ROW($A$1)+1)>0,ROW($A$1:$A$5)-ROW($A$1)+1),ROW(A1))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.