Thanks Biff!

Yes, I missed the OP's first post.

Also, thanks for confirming for me that the solution I offered works.
It's nice to know. :)

In article ,
"Biff" wrote:

Domenic, just to FYI,

This OP first posted about a week ago.

He has a range of cells 5 columns by 15 rows and within
that range are random blank cells (formula blanks, "").

The OP wanted the MIN of the last 28 cells in the range
that have a number in them. I gave him an Offset formula
that puts the multi column multi row range into a single
column range. That way, it would be easy to get the MIN.

Biff

-----Original Message-----
In article <E4965B9D-9188-451D-B1C9-
,
"sac73" wrote:

Just the lowest, and the second lowest.... Problem
is, although almost
impossible, all 28 could be the low number.... More
often than not, there
are 2 or 3 multiple 'lowest' results.

Have you tried the solution I offered?
.