how to delete repeated numbers in a column, make it apears once

's Computer Specifications

how to eliminate repeated numbers/characteres in a column,
e.g
22
22
23
24
24
24
how to make the numbers appear only once.how to delete it if i have a long
list

's Computer Specifications

Use Data | Filter | Advanced Filter

On Apr 3, 10:18*pm, sam <s...@discussions.microsoft.com> wrote:
> how to eliminate repeated numbers/characteres in a column,
> e.g
> 22
> 22
> 23
> 24
> 24
> 24
> how to make the numbers appear only once.how to delete it if i have a long
> list

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Searching for repeated numbers in the same column	JLatham	Microsoft Excel New Users	0	28th Oct 2009 07:50 PM
How do I search for repeated numbers in same column	MB	Microsoft Excel New Users	1	28th Oct 2009 07:16 PM
Column with repeated numbers	Jcol	Microsoft Excel Worksheet Functions	1	23rd Jan 2008 03:24 PM
delete repeated numbers	=?Utf-8?B?TGFibWFu?=	Microsoft Excel Worksheet Functions	1	10th Sep 2005 07:34 PM
Delete repeated numbers in Excel	=?Utf-8?B?TGFibWFu?=	Microsoft Excel Worksheet Functions	1	10th Sep 2005 02:24 PM