+ Reply to Thread
Results 1 to 4 of 4

counting and weeding out duplicates

  1. 09-05-2013, 06:00 PM #1
    tudelson
    tudelson is offline
    Registered User
    Join Date
    03-10-2011
    Location
    cleveland,ohio
    MS-Off Ver
    Excel 2007
    Posts
    2

    counting and weeding out duplicates

    how do i count duplicates in a sheet , count them and delete the unneeded entries
    Reply With QuoteRegister To Reply
  2. 09-05-2013, 06:18 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: counting and weeding out duplicates

    Excel 2007+ has a Delete Duplicates function on the Data tab.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 09-05-2013, 11:02 PM #3
    tudelson
    tudelson is offline
    Registered User
    Join Date
    03-10-2011
    Location
    cleveland,ohio
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: counting and weeding out duplicates

    how do i do this without reducing the count to 1 from whatever the previous count had been??
    Reply With QuoteRegister To Reply
  4. 09-05-2013, 11:58 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: counting and weeding out duplicates

    Pardon?

    That's what deleting duplicates does.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] counting duplicates only once
    By eddisign in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-30-2012, 12:40 PM
  2. Counting duplicates
    By madd in forum Excel General
    Replies: 7
    Last Post: 04-17-2009, 11:38 AM
  3. counting cells with data without counting duplicates
    By labettis in forum Excel General
    Replies: 2
    Last Post: 11-05-2007, 12:10 PM
  4. [SOLVED] Data Weeding
    By Maow in forum Excel General
    Replies: 2
    Last Post: 06-07-2006, 04:20 AM
  5. weeding out overlapping items
    By Madenjl in forum Excel General
    Replies: 2
    Last Post: 02-14-2005, 05:37 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1