That works fantastically!
If you have the time, please explain the significance of doing
Ctrl+Shft+Enter.
Thanks,
JT

"R.VENKATARAMAN" wrote:

in addtion to the elegant solution by Mr. Jones if you want to get the
minimum of those values more than a number for example more than 5 use this
formula givn by
Debra Dalgleish
your data is in C2 to C14

=MIN(IF(C2:C120,C2:C12))

and then (this is importatn)
controll+shift +enter.


Norman Jones wrote in message
...
Hi John,

The Min function ignores blank cells, so:

=Min(A1:A100)

--

---
Regards,
Norman



"JohnT" wrote in message
...
I want to display the lowest value e.g. 22.68, 27.89, 28.01... in a
column.
What formula would I need to use?
Thanks in advance!