LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AskExcel
 
Posts: n/a
Default delete duplicate record but only determine 1 column data

Hi,
i want to delete duplicate data in column code with disregard to other
column data. if i use data - filter - advanced filter, this cannot solve my
problem. for example
i just want to delete duplicate record in column code by disregard the
column misc

code misc
1200 40
1300
1300 76
1300
1500
1500 12

after
code misc
1200 40
1300
1500 12

if i use the data - filter - advanced filter
the result is
code misc
1200 40
1300
1300 76
1500
1500 12

 
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
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
How do you Stop Entering Duplicate Data in a Column? Satraj Excel Worksheet Functions 7 November 4th 05 01:04 PM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
match and count words David Excel Worksheet Functions 5 July 4th 05 02:24 AM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM


All times are GMT +1. The time now is 10:38 PM.

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

About Us

"It's about Microsoft Excel"