+ Reply to Thread
Results 1 to 7 of 7

Delete Duplicate Rows based on one duplicating value- and keep total at the top the same.

  1. #1
    Registered User
    Join Date
    01-29-2014
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    3

    Unhappy Delete Duplicate Rows based on one duplicating value- and keep total at the top the same.

    excelquestionphoto.jpg

    Ive looked everywhere on this forum and I can't find an answer. So- here goes. I will fall off my chair if someone can solve this Excel dilemma.

    I need to remove duplicate rows based on values of one cell in the row.

    For instance- I need to delete or hide all but one row of each duplicate PO ID I get (Column H).

    However- I do need to keep the total at the top the same. So I need the hidden cells to still be calculated.

    Does that make sense?

  2. #2
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Delete Duplicate Rows based on one duplicating value- and keep total at the top the sa

    Hi Jeremy,

    Please post a sample spreadsheet.

    An image really doesn't help.

    Regards,

    David

  3. #3
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Delete Duplicate Rows based on one duplicating value- and keep total at the top the sa

    Hi Jeremy,

    Please post a sample spreadsheet.

    An image really doesn't help.

    Having said that, "Remove Duplicates" will keep the first row, and remove any others with the same value in Col H. So you will lose any information. So, we need to look elsewhere since you want to keep inforamtion.

    Regards,

    David

  4. #4
    Registered User
    Join Date
    02-01-2014
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Delete Duplicate Rows based on one duplicating value- and keep total at the top the sa

    i have much expertize in excel, so i can't help you, but i used DuplicateFilesDeleter to fond and remove duplicate files.

  5. #5
    Registered User
    Join Date
    01-29-2014
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Delete Duplicate Rows based on one duplicating value- and keep total at the top the sa

    Thanks so much for your help! So- I want one line to show up for each P0. The total on the line doesn't have to be a subtotal of all lines in the PO- but I want the whole total of the the PO (all lines with dollar amounts) to show up in the total above.

    Let me know if that doesnt make sense.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    01-29-2014
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Delete Duplicate Rows based on one duplicating value- and keep total at the top the sa

    I dont need to permanently remove them but I dont want them to show so the spreadsheet reads easier. We are interested in the main total above- not each individual line total.

  7. #7
    Registered User
    Join Date
    11-21-2014
    Location
    India
    MS-Off Ver
    7
    Posts
    1

    Re: Delete Duplicate Rows based on one duplicating value- and keep total at the top the sa

    DuplicateFilesDeleter works excellent to find duplicate files and delete them quickly than other software. You may also try it and I m sure you will be happy too. Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Delete rows based on duplicate cell, but leaving first and last duplicate.
    By LadyNicole in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2013, 05:07 AM
  2. Delete Duplicate Rows based on All columns
    By king12yan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2010, 02:36 PM
  3. Delete Duplicate Rows Based only 2 columns.
    By ebbo in forum Excel General
    Replies: 2
    Last Post: 02-18-2010, 11:27 AM
  4. Delete duplicate rows based on all columns
    By kiran654 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-30-2010, 08:14 AM
  5. Replies: 5
    Last Post: 05-29-2006, 09:25 AM

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