Lastrow without useing VBA (RESOLVED)

[Skyhook]

Is there a formula that can be placed in a cell to find the last data in another Column?
If possable, without using VBA.
Thanks in advance

[ This Message was edited by: Skyhook on 2002-05-10 09:12 ]

[Colo]

Hi,
How about this.

=MAX(ROW($A1:$A$65535)*($A$1:$A$65535<>""))

After input this formula, press Ctrl + Shift + Enter

[Skyhook]

Colo,

That isn’t quite it. I have data in Column V7:V37. What I need is a formula in Column W7 that will get the data in the last cell in Column V. I don’t know if it will make a difference but Column V7:V37 contains formulas .

Thanks

[Aladin Akyurek]

On 2002-05-10 05:43, Skyhook wrote:
Colo,

That isn?t quite it. I have data in Column V7:V37. What I need is a formula in Column W7 that will get the data in the last cell in Column V. I don?t know if it will make a difference but Column V7:V37 contains formulas .

Thanks

Is column V numeric?


In case it is,

In W7 enter:

=INDEX(V7:V37,MATCH(9.99999999999999E+307,V7:V37))

Aladin


[ This Message was edited by: aladin akyurek on 2002-05-10 06:30 ]

[Skyhook]

Yes. In Column V7 is S7+T7+U7. What i need is for column W to look for the last data in column V. If Column S7:U7 has no data then there will be a 0 in column V7. Hope this helps.

Thanks

[Aladin Akyurek]

On 2002-05-10 06:28, Skyhook wrote:
Yes. In Column V7 is S7+T7+U7. What i need is for column W to look for the last data in column V. If Column S7:U7 has no data then there will be a 0 in column V7. Hope this helps.

Thanks

See my edited reply.

[Skyhook]

Aladin,
It is working but it is returning a 0 value. I tried hiding 0 values but this didnt work.

in column v7 is 22.0 In column v8 is 22.5 in coulmn v9:v37 is 0. I need the formula to ignore the 0's and return 22.5

Thanks

[Aladin Akyurek]

On 2002-05-10 06:56, Skyhook wrote:
Aladin,
It is working but it is returning a 0 value. I tried hiding 0 values but this didnt work.

in column v7 is 22.0 In column v8 is 22.5 in coulmn v9:v37 is 0. I need the formula to ignore the 0's and return 22.5

Thanks

In that case, we need an expensive formula:

=INDEX(V9:V37,SUMPRODUCT(MAX((V9:V37>0)*(ROW(V9:V37)))))

Aladin

[Skyhook]

Aladin
I tried the formula but it is still returning the 0 value. If you know of an easier way I am definitely up for suggestions
Thanks for all your help

[Aladin Akyurek]

On 2002-05-10 08:40, Skyhook wrote:
Aladin
I tried the formula but it is still returning the 0 value. If you know of an easier way I am definitely up for suggestions
Thanks for all your help

Jotting down things like that... No wonder.

Change it to:

=INDEX(V:V,SUMPRODUCT(MAX((V9:V37>0)*(ROW(V9:V37)))))