Last Cell Info
 

I have a column lets call it F that has 53 rows.
Numbers go into the cell after something is entered in another column so it
is a formula.

I want to use the last number in that F column. It may be in any row from 1
through 53.

Is there a way to get that number.

Thanks in advance
Ed Davis

Last Cell Info
 

For the last numerical value, try...

=LOOKUP(9.99999999999999E+307,F1:F53)

Hope this helps!

In article ,
"Ed Davis" wrote:

I have a column lets call it F that has 53 rows.
Numbers go into the cell after something is entered in another column so it
is a formula.

I want to use the last number in that F column. It may be in any row from 1
through 53.

Is there a way to get that number.

Thanks in advance
Ed Davis

Last Cell Info
 

Try

=LOOKUP(99^99,F1:F53)


--
Regards,

Peo Sjoblom




"Ed Davis" wrote in message
...
I have a column lets call it F that has 53 rows.
Numbers go into the cell after something is entered in another column so
it is a formula.

I want to use the last number in that F column. It may be in any row from
1 through 53.

Is there a way to get that number.

Thanks in advance
Ed Davis

Last Cell Info
 

The cell I put this formula in stays blank.
Thanks for you help though.

"Peo Sjoblom" wrote in message
...
Try

=LOOKUP(99^99,F1:F53)


--
Regards,

Peo Sjoblom




"Ed Davis" wrote in message
...
I have a column lets call it F that has 53 rows.
Numbers go into the cell after something is entered in another column so
it is a formula.

I want to use the last number in that F column. It may be in any row from
1 through 53.

Is there a way to get that number.

Thanks in advance
Ed Davis

Last Cell Info
 

The sell that I put this formula in stays blank.
Thanks for your help though.

"Domenic" wrote in message
...
For the last numerical value, try...

=LOOKUP(9.99999999999999E+307,F1:F53)

Hope this helps!

In article ,
"Ed Davis" wrote:

I have a column lets call it F that has 53 rows.
Numbers go into the cell after something is entered in another column so
it
is a formula.

I want to use the last number in that F column. It may be in any row from
1
through 53.

Is there a way to get that number.

Thanks in advance
Ed Davis

Last Cell Info
 

That's impossible, it will return either #N/A or the last numerical value
(if there are no numbers)

--
Regards,

Peo Sjoblom


"Ed Davis" wrote in message
...
The cell I put this formula in stays blank.
Thanks for you help though.

"Peo Sjoblom" wrote in message
...
Try

=LOOKUP(99^99,F1:F53)


--
Regards,

Peo Sjoblom




"Ed Davis" wrote in message
...
I have a column lets call it F that has 53 rows.
Numbers go into the cell after something is entered in another column so
it is a formula.

I want to use the last number in that F column. It may be in any row
from 1 through 53.

Is there a way to get that number.

Thanks in advance
Ed Davis

Last Cell Info
 

There are numbers between in cells f11 through f17.

When I change the lookup to f1-f17 I do get the number I am looking for that
is in row 17. But leaving the lookup as it is shows me nothing.
Remember there are formula's in almost every other row.


"Peo Sjoblom" wrote in message
...
That's impossible, it will return either #N/A or the last numerical value
(if there are no numbers)

--
Regards,

Peo Sjoblom


"Ed Davis" wrote in message
...
The cell I put this formula in stays blank.
Thanks for you help though.

"Peo Sjoblom" wrote in message
...
Try

=LOOKUP(99^99,F1:F53)


--
Regards,

Peo Sjoblom




"Ed Davis" wrote in message
...
I have a column lets call it F that has 53 rows.
Numbers go into the cell after something is entered in another column
so it is a formula.

I want to use the last number in that F column. It may be in any row
from 1 through 53.

Is there a way to get that number.

Thanks in advance
Ed Davis

Last Cell Info
 

I just realized that the formula = 0 unless something is in another cell.
Is there a way to just look for a number other than 0?





"Ed Davis" wrote in message
...
There are numbers between in cells f11 through f17.

When I change the lookup to f1-f17 I do get the number I am looking for
that is in row 17. But leaving the lookup as it is shows me nothing.
Remember there are formula's in almost every other row.


"Peo Sjoblom" wrote in message
...
That's impossible, it will return either #N/A or the last numerical value
(if there are no numbers)

--
Regards,

Peo Sjoblom


"Ed Davis" wrote in message
...
The cell I put this formula in stays blank.
Thanks for you help though.

"Peo Sjoblom" wrote in message
...
Try

=LOOKUP(99^99,F1:F53)


--
Regards,

Peo Sjoblom




"Ed Davis" wrote in message
...
I have a column lets call it F that has 53 rows.
Numbers go into the cell after something is entered in another column
so it is a formula.

I want to use the last number in that F column. It may be in any row
from 1 through 53.

Is there a way to get that number.

Thanks in advance
Ed Davis

Last Cell Info
 

I am saying that the formula cannot return nothing, either you will get an
error or you will get a number. Nothing is impossible. If your values are
text numbers you will get #N/A. To me it sounds as though you have changed
the formula somehow and I don't see what formulas in every other row has
anything to do with this?


--
Regards,

Peo Sjoblom



"Ed Davis" wrote in message
...
There are numbers between in cells f11 through f17.

When I change the lookup to f1-f17 I do get the number I am looking for
that is in row 17. But leaving the lookup as it is shows me nothing.
Remember there are formula's in almost every other row.


"Peo Sjoblom" wrote in message
...
That's impossible, it will return either #N/A or the last numerical value
(if there are no numbers)

--
Regards,

Peo Sjoblom


"Ed Davis" wrote in message
...
The cell I put this formula in stays blank.
Thanks for you help though.

"Peo Sjoblom" wrote in message
...
Try

=LOOKUP(99^99,F1:F53)


--
Regards,

Peo Sjoblom




"Ed Davis" wrote in message
...
I have a column lets call it F that has 53 rows.
Numbers go into the cell after something is entered in another column
so it is a formula.

I want to use the last number in that F column. It may be in any row
from 1 through 53.

Is there a way to get that number.

Thanks in advance
Ed Davis

Last Cell Info
 

The formulas return a zero. And I had zeros turned off so that is why I saw
nothing. The actual number is a zero.


"Peo Sjoblom" wrote in message
...
I am saying that the formula cannot return nothing, either you will get an
error or you will get a number. Nothing is impossible. If your values are
text numbers you will get #N/A. To me it sounds as though you have changed
the formula somehow and I don't see what formulas in every other row has
anything to do with this?


--
Regards,

Peo Sjoblom



"Ed Davis" wrote in message
...
There are numbers between in cells f11 through f17.

When I change the lookup to f1-f17 I do get the number I am looking for
that is in row 17. But leaving the lookup as it is shows me nothing.
Remember there are formula's in almost every other row.


"Peo Sjoblom" wrote in message
...
That's impossible, it will return either #N/A or the last numerical
value (if there are no numbers)

--
Regards,

Peo Sjoblom


"Ed Davis" wrote in message
...
The cell I put this formula in stays blank.
Thanks for you help though.

"Peo Sjoblom" wrote in message
...
Try

=LOOKUP(99^99,F1:F53)


--
Regards,

Peo Sjoblom




"Ed Davis" wrote in message
...
I have a column lets call it F that has 53 rows.
Numbers go into the cell after something is entered in another column
so it is a formula.

I want to use the last number in that F column. It may be in any row
from 1 through 53.

Is there a way to get that number.

Thanks in advance
Ed Davis

Last Cell Info
 

If indeed you have a zero in the last cell it will return that, try this
instead

=LOOKUP(2,1/(F1:F53<0),F1:F53)


--
Regards,

Peo Sjoblom



"Ed Davis" wrote in message
...
I just realized that the formula = 0 unless something is in another cell.
Is there a way to just look for a number other than 0?





"Ed Davis" wrote in message
...
There are numbers between in cells f11 through f17.

When I change the lookup to f1-f17 I do get the number I am looking for
that is in row 17. But leaving the lookup as it is shows me nothing.
Remember there are formula's in almost every other row.


"Peo Sjoblom" wrote in message
...
That's impossible, it will return either #N/A or the last numerical
value (if there are no numbers)

--
Regards,

Peo Sjoblom


"Ed Davis" wrote in message
...
The cell I put this formula in stays blank.
Thanks for you help though.

"Peo Sjoblom" wrote in message
...
Try

=LOOKUP(99^99,F1:F53)


--
Regards,

Peo Sjoblom




"Ed Davis" wrote in message
...
I have a column lets call it F that has 53 rows.
Numbers go into the cell after something is entered in another column
so it is a formula.

I want to use the last number in that F column. It may be in any row
from 1 through 53.

Is there a way to get that number.

Thanks in advance
Ed Davis

Last Cell Info
 

That worked thank you very much.


"Peo Sjoblom" wrote in message
...
If indeed you have a zero in the last cell it will return that, try this
instead

=LOOKUP(2,1/(F1:F53<0),F1:F53)


--
Regards,

Peo Sjoblom



"Ed Davis" wrote in message
...
I just realized that the formula = 0 unless something is in another cell.
Is there a way to just look for a number other than 0?





"Ed Davis" wrote in message
...
There are numbers between in cells f11 through f17.

When I change the lookup to f1-f17 I do get the number I am looking for
that is in row 17. But leaving the lookup as it is shows me nothing.
Remember there are formula's in almost every other row.


"Peo Sjoblom" wrote in message
...
That's impossible, it will return either #N/A or the last numerical
value (if there are no numbers)

--
Regards,

Peo Sjoblom


"Ed Davis" wrote in message
...
The cell I put this formula in stays blank.
Thanks for you help though.

"Peo Sjoblom" wrote in message
...
Try

=LOOKUP(99^99,F1:F53)


--
Regards,

Peo Sjoblom




"Ed Davis" wrote in message
...
I have a column lets call it F that has 53 rows.
Numbers go into the cell after something is entered in another
column so it is a formula.

I want to use the last number in that F column. It may be in any row
from 1 through 53.

Is there a way to get that number.

Thanks in advance
Ed Davis