Remove duplicates based while keeping other rows in tact.

**rivertonstudios** · 02-22-2009, 02:35 PM

I have a spreadsheet of products from different suppliers. The suppliers give me information on their price, quantity, descriptions, categories etc. based on one part number.

I need to display the lowest priced product. I also need to combine all suppliers' quantities.

I have attached an example. It doesn't matter to me if I need to use multiple sheets or several formulas.

I wanted to mention I searched the forum up and down for an answer to this. If this has already been posted, I apologize.

Thank you in advance.

**mrice** · 02-22-2009, 03:31 PM

Please see the attachment.

It uses a macro to search for the minimum price for each catalogue number.

Please Login or Register  to view this content.

The first statement inside the For loop makes sure that the catalogue number is processed on its first appearance in the list only. The list need not be sorted by catalogue number.

Hope this helps.

**martindwilson** · 02-22-2009, 03:47 PM

no vba see attached sheet2
you need to prepare a list of non duplicates for use in col a sheet2
you should simply b able to do that with excel2007 remove duplicate function

formula in column b (minif) is array entered with ctrl shift and enter
note in cols b and c the range throught the formula should be the same so if one bit says a3:a600 then the other bit should say b3:b600

Remove duplicates based while keeping other rows in tact.

LinkBack

Thread Tools

Rate This Thread

Display

Remove duplicates based while keeping other rows in tact.

Re: Remove duplicates based while keeping other rows in tact.

Re: Remove duplicates based while keeping other rows in tact.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions