Scan rows for duplicate column values, then add rows together and delete unused rows.

**bnasty** · 11-10-2012, 07:53 PM

SampleWS.xlsx

Here is a sample worksheet. In column H, there will be duplicate values (names) where a customer ordered multiple items in one order OR placed multiple separate orders. I want to add the amounts in column E for all the rows with the same name in Column H then delete the remaining rows for that name.

For example on "Universal Media Sales" The row would read:

Oct-01-12 Product G,I,J 4 $xx.xx $66.84 ZZZZZZZZ UniversalMediaSales Universal Media Sales Universal Media Sales

Thanks again for the help, I've been working on this forever!

**FDibbins** · 11-10-2012, 08:26 PM

to delete the rows on the fly, you would VBA. however, you can use this to identify the duplicates and sum their values, copied down

=IF(COUNTIF(H:H,H2)>1,"",SUMIF(H:H,H2,E:E))

you could then either hide all rows based on that formula that have "no values", or you could copy all of those formulas you just created, then past them to themselves as values...and then delete all rows with nothing in them

**bnasty** · 11-11-2012, 12:27 PM

SampleWS.xlsx

Not sure I entirely understood what you were saying. Here is what I've got so far...the formulas were copied into column F. The duplicate valued rows haven't added anything.

Thanks for the help!! Almost there...

**bnasty** · 11-12-2012, 07:10 PM

Anybody have a followup on this??

**abousetta** · 11-12-2012, 07:41 PM

This is the vba equivalent of what FDibbins was suggesting.

Please Login or Register  to view this content.

abousetta

P.S. Remember to test on a copy of your actual data.

**abousetta** · 11-12-2012, 08:38 PM

I think the formula you are looking for is:

Formula:

Please Login or Register  to view this content.

in F2 and dragged down

abousetta

Scan rows for duplicate column values, then add rows together and delete unused rows.

LinkBack

Thread Tools

Rate This Thread

Display

Scan rows for duplicate column values, then add rows together and delete unused rows.

Re: Scan rows for duplicate column values, then add rows together and delete unused rows.

Re: Scan rows for duplicate column values, then add rows together and delete unused rows.

Re: Scan rows for duplicate column values, then add rows together and delete unused rows.

Re: Scan rows for duplicate column values, then add rows together and delete unused rows.

Re: Scan rows for duplicate column values, then add rows together and delete unused rows.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions