# Display the line number of the first unused row

#### mistawicket

##### New Member
Hello!
New to the site & the search option didn't help me find what I was looking for...

Is there a simple formula I can enter in a cell to display the first blank line I have in a range of B6:B2000, without using a macro?

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

##### MrExcel MVP
hi - welcome to the board.

=MIN(IF(LEN(A1:A10)=0,ROW(A1:A10)))

..entered with control + shift + enter, not just enter.

#### mistawicket

##### New Member
Thnx for the welcome... Wow that was a fast response...

so If I use what you posted...

"
=MIN(IF(LEN(A1:A10)=0,ROW(A1:A10)))
"

but replace the range with my data:

=MIN(IF(LEN(B6:B2000)=0,ROW(B6:B2000)))

then it should show the first unused cell & not the last empty cell?

Gravy! I tried it & it worked...! Thnx for the info!

Out of curiosity, why do you have to enter this formula while holding crtl + shift?

##### MrExcel MVP
check out the excel help topic on 'array formulas & how to enter them' (or something like that)

#### mistawicket

##### New Member
will do... Thnx again!

#### Yogi Anand

##### MrExcel MVP
Hi mistawicket:

Welcome to MrExcel Board!

Try the following array formula ...

=MIN(IF(B6:B2000="",ROW(B6:B2000)))

an array formula is entered with CTRL+SHIFT+ENTER rather than with just ENTER

#### mistawicket

##### New Member
Thanks Yogi! Thar formula worked too... Kinda crazy how there are multiple ways to do the same thing...!

Replies
5
Views
269
Replies
3
Views
319
Replies
13
Views
262
Replies
71
Views
1K
Replies
2
Views
148

1,191,182
Messages
5,985,168
Members
439,944
Latest member
Vangelis74

### 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.

### Which adblocker are you using?

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

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