Skipping repeating entries

[ashish514]

Think I've done this before but can't recall how. I have a single column with large no. of rows. There are several repetitive entries in the column. What I need is another column showing each entry only once. I hope it is clear

 

[SteveO59L]

Try posting a sample of your data, and what you would like to do with it

 

[jeffmb]

1. Select column

2. Select Advanced Filter on Data tab

3. On dialog box

a. select Copy to another location
b. click in Copy to: and then select the column where you want to copy to
c.Check Unique records only check box
d. Click OK
​

 

[Firefly2012]

Formula-wise, perhaps you mean something like this:

Excel 2007
	A	B
1	Repeated List	Unique List
2	Dog	Dog
3	Cat	Cat
4	Horse	Horse
5	Cat	Mouse
6	Cat	Rabbit
7	Mouse	Fly
8	Mouse	#N/A
9	Rabbit	#N/A
10	Fly	#N/A
11	Fly	#N/A
12	Fly	#N/A
Sheet3

Cell Formulas
Range	Formula
B2	{=INDEX($A$2:$A$12,MATCH(TRUE,COUNTIF($B$1:$B1,$A$2:$A$12)=0,0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

The absolute easiest way though would be either to use Advanced Filter (copy to another location and check Unique Records Only) or a pivot table with this field moved into the row source area.

 

[ashish514]

Oh right,
how silly of me. Thanks everybody...thanks a lot.