MIN expects numeric values.

If it is always A at the start, you could use

=MIN(--SUBSTITUTE(A1:A5,"A",""))

or

=MIN(--RIGHT(A1:A5,LEN(A1:A5)-1))

which are array formulae, they should be committed with Ctrl-Shift-Enter,
not just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Malmo" wrote in message
...
When i make inquiery to different companys, i get 4-5 different prices.

I wish to find the lowest price and bold/make cell yellow.

Ex.

A6
A62
A112
A184
A230

How can i do this? I keep getting a Error when using min fuction.