Extract lowest value from data set

[Russ At Index]

Hi Excellers ...
I wonder if anyone can assist .
I have a data set that contains product code and a cost associated with that code.Column A & B
The issue i have is , for some reason there are more than one cost attached to each code ( weird )
Eg
Code
1234 £1.99
1234 £2.99
222 £3.99
3456 £14.99
3456 £12.99
I would like to report the lowest cost against each code , is there any way Excel can perform this task ?.

Thanks in advance ,

Russ

 

[Fluff]

You're welcome & thanks for the feedback

 

[Fazza]

Pivot tables are great for this sort of task.

Assuming the data is in a simple table - such as headers in row 1 & data below that in a contiguous block - select a cell in the table and then ALT-D-P and then three times press RETURN. This will create a blank pivot table and a list of the headers. Via the mouse is one way to drag the fields into the layout - the code on the LHS in what is called a row field, and the cost in the Values or data area. Via a right click from the data field the cost can be set to show the minimum value (and that will be minimum per row field / column field combination).

So, uses no code & no formulas. Please google for examples/help. HTH