Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 846
Default Find Duplicate names and delete problem

Typed in
"Name1" into C2
"Name2" into C3
"Name3" into C4

Selected these three names and copied them down through cell C26

Using Data-filter-Advance filter
Action - copy to
List range C2:C26
Clicked the Unique records only and selected E2
Clicked okay

Results was
Name1
Name2
Name3
Name1

Any idea why Name1 was repeated?
Copied C2:C26 over to h2 (sorted the list) and all "Name1" are identical


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 457
Default Find Duplicate names and delete problem

Since Adv Filter requires a header row, the first "Name 1" is treated as the
header, and copied over no matter what.

--
Best Regards,

Luke M
"Brad" wrote in message
...
Typed in
"Name1" into C2
"Name2" into C3
"Name3" into C4

Selected these three names and copied them down through cell C26

Using Data-filter-Advance filter
Action - copy to
List range C2:C26
Clicked the Unique records only and selected E2
Clicked okay

Results was
Name1
Name2
Name3
Name1

Any idea why Name1 was repeated?
Copied C2:C26 over to h2 (sorted the list) and all "Name1" are identical




  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Find Duplicate names and delete problem

Most likely Excel is seeing top name1 as a title.

Add something to C1 then select C1:C26 and inform Excel that C1 is a title.


Gord Dibben MS Excel MVP

On Fri, 12 Mar 2010 07:08:08 -0800, Brad
wrote:

Typed in
"Name1" into C2
"Name2" into C3
"Name3" into C4

Selected these three names and copied them down through cell C26

Using Data-filter-Advance filter
Action - copy to
List range C2:C26
Clicked the Unique records only and selected E2
Clicked okay

Results was
Name1
Name2
Name3
Name1

Any idea why Name1 was repeated?
Copied C2:C26 over to h2 (sorted the list) and all "Name1" are identical


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
Find Duplicate names and delate Find Duplicate names and delate Excel Discussion (Misc queries) 4 March 12th 10 03:08 PM
Find and Delete Duplicate entries Barry Walker Excel Discussion (Misc queries) 10 July 9th 07 06:02 PM
How do you delete duplicate addresses, but keep duplicate names? Shelly Excel Discussion (Misc queries) 1 August 28th 06 10:36 PM
delete duplicate names in a column jaya New Users to Excel 1 October 21st 05 09:53 AM
Creating a macro to find duplicate names Carter Devereaux Excel Discussion (Misc queries) 1 July 6th 05 10:39 PM


All times are GMT +1. The time now is 08:49 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"