PC Review


Reply
Thread Tools Rate Thread

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

 
 
sam
Guest
Posts: n/a
 
      3rd Apr 2008
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
 
Reply With Quote
 
 
 
 
muddan madhu
Guest
Posts: n/a
 
      3rd Apr 2008
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


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:19 AM.