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!