How to have conditional row delete using excel????

Question

Hi!
I Would REALLY appreciate it if some one can help me with this!
I have multiple csv files (tables) with product data. Each csv table has a Product ID and a price. I want to compare ALL the SAME product IDs prices and delete the higher price.
e.g. (assuming all products are in one table):
ID Price
111 $5
114 $23
112 $5
111 $2
I want to (using excel or anything else) filter that list to only contain the cheapest product, so it looks like this:
ID Price
114 $23
112 $5
111 $2
So the the other product with ID 111 was deleted because it was compared to all the IDs and when it came to the last one it checked the price because it had the same ID and it deleted the record with the higher price.
I need to compare EVERY record(product ID) to EVERY other record to ensure i get all duplicates.

PLEASE PLEASE PLEASE HELP!
Thankyou

Thanks so much for your reply!
I probably should have mentioned tho that im a COMPLETE NEWBEE to excel and i needed step by step key press by keypress inctuctions. I will learn as i go!
thanks for your time anyways!

Answer 1

It sounds like a macro solution to me
In the VBA of Excel, you can do almost anything you need
(Visit my site and see what i did with it http://www.projects.file1.net)
Now, if you like, send me a sample of what you want using my e-mail in my site

And I can do it for you

Trust me, I am the VBAXLMan here

Answer 2

I did it this way:
If your "data" is in A and B starting at row 3

Here is a formula for column E that puts the minimum price in E1 for the part# you enter into E2.
The "IF" has to be filled down to the bottom of your data (see "auto fill" if you don't know how to do that)
I used part # 111 in the example below

=MIN(E3:E8)
111
=IF($A3=E$2,$B3,"")

=IF($A4=E$2,$B4,"")
.
.
.
.
The "MIN" has to include all rows of data. above it is good for only 6 rows (E3:E13) would cover 10 etc.
This can also be filled to the right F, G, H etc. to allow multiple part #s to be entered (in F2, G2 etc).

Answer 3

Well I have just done it but I am not sure that I can guarantee the results.

First sort your data. Column A(ID) ascending and Column B(Price) decsending.
Now in column c2 put the following formula. This is of course assuming that your data starts in row 2.
=if(lookup(a2,a:a,b:b) < b2,false(),true())
Now copy this to all rows.
Now use data filter to show all false rows and then select them and using edit click on delete to remove the highlighted rows.