Reference to row

[PT]

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
	B	C	D	E	F	G
3	3
4		11
5					15
6		3		8
7	1		15		2
8		4
9
10	10		45
11
12		7		7	3
13			50
14
15
16					5
17
18				1
19
20						8
21
Sheet1

 

[SteveO59L]

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)

 

[Domenic]

Try...

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

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

Hope this helps!

 

[GlennUK]

In a single cell put:

=MAX(IF(NOT(ISBLANK(B1:G5000)),ROW(B1:G5000),0))

entered using Ctrl-Shift-Enter instead of Enter.

 

[PT]

Hi steve,

Your formula works nice.

Thanks,

Ismael