+ Reply to Thread
Results 1 to 8 of 8

Excel, Counting & deleting dupliate rows ? possible ?

  1. #1
    Registered User
    Join Date
    04-05-2012
    Location
    BelgiŽ
    MS-Off Ver
    Excel 2010
    Posts
    4

    Excel, Counting & deleting dupliate rows ? possible ?

    Hi, I'm currently working at a shop where they want to make some work lighter by removing the duplicate bar codes out of the system but keeping the amount of them.
    Since Words don't say as much as images I added the begin stage & the desired result state. This example is on a small scale but it would need to be for large excel sheets.

    Begin State.JPG Result state.JPG

    I hope this helps, Also I would like to add that i'm not that amazing with excel, so if there even is a solution to this. Please help out on how to make it work.
    Thanks alot in advance ! This would be lots less work if it worked.

    Greetings Tim
    Last edited by Duofilm; 04-05-2012 at 05:15 AM.

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Excel, Counting & deleting dupliate rows ? possible ?

    In the 'Data' menu there's a 'Delete duplicates' function - just run that and tell it which column your bar-codes are in, and that should be you sorted.

  3. #3
    Forum Expert
    Join Date
    09-27-2011
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    1,312

    Re: Excel, Counting & deleting dupliate rows ? possible ?

    and the next step is function countif
    Regards

    tom1977

    If You are satisfied with my solution click the small star icon on the left to say thanks.

  4. #4
    Registered User
    Join Date
    04-05-2012
    Location
    BelgiŽ
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Excel, Counting & deleting dupliate rows ? possible ?

    This function deletes my duplicates alright but, I don't know how many of them I had after running it. You you look at my second image "Result State.JPG" in my first post you see that I still require to know the count of how many I had in the past.
    thanks for the comment though. But its not really a solve for me.

  5. #5
    Registered User
    Join Date
    04-05-2012
    Location
    BelgiŽ
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Excel, Counting & deleting dupliate rows ? possible ?

    Quote Originally Posted by tom1977 View Post
    and the next step is function countif
    How exactly do I use this then ? Sorry but like I said i'm a basic in this.
    Thanks for the info though !

  6. #6
    Forum Expert
    Join Date
    09-27-2011
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    1,312

    Re: Excel, Counting & deleting dupliate rows ? possible ?

    look into attachment
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    04-05-2012
    Location
    BelgiŽ
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Excel, Counting & deleting dupliate rows ? possible ?

    Well, both the Function in the Data menu & the countif function work amazing by themselves.
    They don't do the job though when trying to combine them together to get my result.
    Cause if I first run the countif function it will ofc count everything in my Data list that occurs more then 1 time, but when I remove the duplicates it will also change the formule. That means that my count values all go to 1. And I guess thats normal since I removed all the extra's.

  8. #8
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Excel, Counting & deleting dupliate rows ? possible ?

    If you put the CountIf formula in then copy the results and use Paste Special|Values to overwrite the formula with the results and then use the delete duplicates you should be there.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1