#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 68
Default list double entries

Hi,

I want to list all double or more entries in in column.

After checking I also want to be able to delete the "double" rows
following the first or clear its cell contents.

A solution in 2 steps is greatly appreciated.

Cheers,

Harold

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default list double entries

Check out

http://www.cpearson.com/Excel/Duplicates.aspx

In article om,
mohavv wrote:

Hi,

I want to list all double or more entries in in column.

After checking I also want to be able to delete the "double" rows
following the first or clear its cell contents.

A solution in 2 steps is greatly appreciated.

Cheers,

Harold

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Checking for double entries The Fool on the Hill Excel Discussion (Misc queries) 6 November 16th 06 12:07 PM
Remove double data entries Nicole Excel Discussion (Misc queries) 2 November 16th 05 08:40 PM
Check for double entries in a row Pierrot Robert Excel Worksheet Functions 1 September 5th 05 06:37 PM
Sorting lists to remove double entries nicad_adam Excel Discussion (Misc queries) 2 June 14th 05 06:55 AM
count data but avoid double entries Manos Excel Worksheet Functions 1 December 14th 04 07:00 AM


All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"