Advertisement

05.29.2008 at 10:20AM PDT, ID: 23442190
[x]
Attachment Details

Keep only duplicates in a given column and delete all Uniques

Asked by jasdak in Microsoft Excel Spreadsheet Software

Tags: Microsoft, Excel, 2003 and 2007, Keep only duplicates

I have searched the DB of questions here and found only help on how to remove duplicate data.  I am in need of scanning all 65k lines and delete all Unique rows.  I am interested only in keeping the duplicate, triplicate, etc. data rows.  I will search for duplicates in column 'K'.  if K20000 and K20100 are equal, i would like to keep the those rows.  All uniques to be removed. Start Free Trial
[+][-]05.29.2008 at 11:02AM PDT, ID: 21671662

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.29.2008 at 12:20PM PDT, ID: 21672445

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.29.2008 at 12:50PM PDT, ID: 21672739

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.29.2008 at 01:06PM PDT, ID: 21672864

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.29.2008 at 01:22PM PDT, ID: 21672989

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.29.2008 at 02:34PM PDT, ID: 21673488

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.29.2008 at 02:38PM PDT, ID: 21673523

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.29.2008 at 04:00PM PDT, ID: 21674033

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]06.02.2008 at 09:00PM PDT, ID: 21697490

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Tags: Microsoft, Excel, 2003 and 2007, Keep only duplicates
Sign Up Now!
Solution Provided By: nds_rahulmistry
Participating Experts: 4
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628