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?

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?

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?

By last, are you referring to their location on the worksheet, i.e. if the
data is in A1:A40, you want to see the lowest in the range A13:A40?

If that's it, then if you want to see the minimum in A41, in that cell

=MIN(OFFSET(A40,-27,0,28,1))



On Thu, 31 Mar 2005 06:11:03 -0800, "sac73"
wrote:

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?

We are on the right track with the offset suggestion, now here is a bit
more....

Let me know if I am asking for too much from the program:

The items that I want are in multiple rows AND multipule columns. Can we
set it to count backwards along a row, then move up and continue counting,
ignoring cells with no entries, until it has checked 28?

eg. There are 50 items in A1:E15, meaning there are 15 random cells with no
entries.

"Myrna Larson" wrote:

By last, are you referring to their location on the worksheet, i.e. if the
data is in A1:A40, you want to see the lowest in the range A13:A40?

If that's it, then if you want to see the minimum in A41, in that cell

=MIN(OFFSET(A40,-27,0,28,1))



On Thu, 31 Mar 2005 06:11:03 -0800, "sac73"
wrote:

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?

Perhaps =LARGE(A1:E15,28) will do what you want. It will return the 28th
largest value in the range.


On Thu, 31 Mar 2005 17:03:02 -0800, "sac73"
wrote:

We are on the right track with the offset suggestion, now here is a bit
more....

Let me know if I am asking for too much from the program:

The items that I want are in multiple rows AND multipule columns. Can we
set it to count backwards along a row, then move up and continue counting,
ignoring cells with no entries, until it has checked 28?

eg. There are 50 items in A1:E15, meaning there are 15 random cells with no
entries.

"Myrna Larson" wrote:

By last, are you referring to their location on the worksheet, i.e. if the
data is in A1:A40, you want to see the lowest in the range A13:A40?

If that's it, then if you want to see the minimum in A41, in that cell

=MIN(OFFSET(A40,-27,0,28,1))



On Thu, 31 Mar 2005 06:11:03 -0800, "sac73"

wrote:

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?

Hi!

Where are these "active cells"?

In a row? A1:IV1

In a column? A1:A65536

Just FYI, in Excel, active cell is a standard term that
means the cell that is currently selected. When you move
the cursor and select cell A1, cell A1 becomes the active
cell.

Biff

-----Original Message-----
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
news:207089F2-80B4-46C8-863D-
...
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?



.