Reference to row

PT

Board Regular
Joined
Feb 4, 2005
Messages
103
Hi to all in the forum,

I have a doubt about reference to rows, as you guys can see in the picture attach I have several values between columns B and G.
What I pretend is a formula that return the number of the row were is the last value, in this case in row 20 on column G, but I only need to now the number of the row, that is 20.

So if any of you guys can help me I really appreciate.

Best regards,

Ismael
Book1
BCDEFG
33
411
515
638
71152
84
9
101045
11
12773
1350
14
15
165
17
181
19
208
21
Sheet1
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Somthing like,

In I1, =IF(SUM(A1:G1)>0,ROW(),""), and copied down through your range.

Then at the end of your range

=MAX(I1:I20)
 
Upvote 0
Try...

=MAX(IF(B3:G21<>"",ROW(B3:G21)))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Adjust the range accordingly.

Hope this helps!
 
Upvote 0
In a single cell put:
Code:
=MAX(IF(NOT(ISBLANK(B1:G5000)),ROW(B1:G5000),0))
entered using Ctrl-Shift-Enter instead of Enter.
 
Upvote 0

Forum statistics

Threads
1,211,710
Messages
6,103,451
Members
447,866
Latest member
bowers261

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