Active is defined as a numeric entry... Let me also better define:
40 cells - 35 active (numbers in them) - I want to count the last 28, and
then get the lowest number (Min)

"Bob Phillips" wrote:

What defines active?:

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sac73" wrote in message
...
Is there a way to count back a certain number of active cells only (eg. 40
possible cells, only 28 are active), and then enter the lowest number
within
that range into a cell?