Lastrow without useing VBA (RESOLVED)

Skyhook

New Member
Joined
Apr 8, 2002
Messages
38
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
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Hi,
How about this.

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

After input this formula, press Ctrl + Shift + Enter
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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)))))
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,034
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top