need formula to compare 2 colums and keep a a value that is lower

**mtanislav** · 05-14-2011, 05:49 AM

Hello,

I have 2 colums.

A B

43 fgh-23-_1
54,5 fgh-23-_1
22 kl982323
90 kl982323
50 lw-kmn/32
45 lw-kmn/32

Can you please tell me a solution to check for duplicate cells in column B and if he founds a duplicate, to check and see what value is in column A and keep the row with the smallest value in A.

I show end up with this:

A B

43 fgh-23-_1
22 kl982323
45 lw-kmn/32

Please tell me there is a solution for this. Thank you very much for your help. I really appreciate it.

this is found in http://www.pcreview.co.uk/forums/nee...-t4035916.html
http://www.ozgrid.com/forum/showthread.php?t=154032
http://www.mrexcel.com/forum/showthread.php?p=2716399

**arthurbr** · 05-14-2011, 06:42 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

http://www.mrexcel.com/forum/showthread.php?t=550050

**royUK** · 05-14-2011, 07:54 AM

mtanislav

I strongly suggest that you actually read the Forum Rules before posting again

**mtanislav** · 05-14-2011, 08:49 AM

I did not explain this very well.

Here it is again.

download the sample data from here http://www.2shared.com/document/2Vlm8cWU/sample.html (the sample only has a 20 items, the original one has 21000) and some products are the same from even 8 suppliers.

I want to get rid of the duplicate products with the same reference and keep just the one with the smallest price.

I hope I explained now correctly.

Thanks again for all your help.