Finding first blank row number

[cab401]

Help! This formula referencing text within the same page, works perfectly in returning the first blank row number:

{=min(if(indirect(“A”&J17):A26=“”,row(indirect(“A”&J17):A26),””))}

However, similar formula below referencing another page returns #VALUE!

{=min(if(indirect(IA&“!A”&J17):A26=“”,row(indirect(IA&“!A”&J17):A26),””))}

IA contains a separate (open) worksheet name.

 

[Aladin Akyurek]

What is IA?

 

[cab401]

Sorry, that should have said I1. That is where the separate sheet name is. I typed it incorrectly above but it is correct in the actual formula. But this doesn’t work so I’m assuming it’s a syntax issue with a parentheses in the wrong place or something like that.

 

[Aladin Akyurek]

Control+shift+enter:

=MIN(IF(INDIRECT(I1&"!A"&J17):A26="",ROW(INDIRECT(I1&"!A"&J17):A26)))

 

[cab401]

Thanks but I’m still getting the error message.

 

[Aladin Akyurek]

Thanks but I’m still getting the error message.

Control+shift+enter: Press down the control and the shift keys at the same time while you hit the enter key. If done successfully, Excel itself puts a pair of { and } arount the formula in recognition.

Book1
	A	B	C	D	E	F	G	H	I	J
1									Sheet1
2	26
17										25
24
25	12
26
Sheet1

 

[cab401]

I tried that. Not sure what’s happening but it’s still not working.

 

[Aladin Akyurek]

I tried that. Not sure what’s happening but it’s still not working.

What do you have in I1 exactly?