Return row number of blank row

[straubj]

I have a set of spreadsheets and each one has a blank line somewhere in the middle area. I need a formula that I can place at the bottom of each spreadsheet that returns the row number of the blank row in each one. All help is very appreciated!

[:) Sixthsense :)]

Try something like this..

Array Formula - Requires CTRL+SHIFT+ENTER

Please Login or Register  to view this content.

Drag it down..

[Lemice]

Hello,

In case you want to count the number of blank rows, you can use this formula

Please Login or Register  to view this content.

You will need to adjust A1:A11 to your real file (If you have 1000 rows for example, it will be A1:A1000)

This is just a normal formula. It will count the number of blank cell in a column (If you place it on a column that must have a value, you can easily point out which row is blank). The downside is that if your cell has "" in it, it won't be counted as blank.

[:) Sixthsense :)]

Double Posted

[Lemice]

Double posted.

[straubj]

I need the blank rows number. I do not need to count the blank row, I know there is only one; I just need to know its location.

[dhn46]

If your date set A1:A100, have some blank cell in A1:A100.
This formula return the blank rows number

Please Login or Register  to view this content.

Finish by: Ctrl + Shift + Enter (not enter) and Fill down
This formula return the end of the blank row number in A1:A100

Please Login or Register  to view this content.

Hope to help you!

[straubj]

This worked! thank you so much!