Hi

I need to find the max and min prices from from a mixed range. The range contains currency, text and numbers.

The range has supplier part numbers and pricing. I need to select pricing data, returned as two columns to give me a total least cost and total max cost from the selection

I've attached a section of my sheet Switch Box.xls

=Min(Range) works by accident - the currency values just happen to be less than the numerical values so is not a true solution. The formula for finding the Min price supplier seems to work though, based on the min value

I've looked at using DMAX to return the most expensive items but don't understand how to set the formula to select currency only.

Any help gratefully received!

Thanks