Excel Lookup Formula 1

[Sopman]

Somedays have data in cells A1,A2,A3,A4,A5,A6
Somedays I have data in A1,A2
Somedays I have data in A1,A2,A3,A4
I'll always have data in A1 and as more data comes in it will go in the next cell, but the most data I will have will be in A1:A6. The least could be just in A1. I never know which row is the last for data.

I would like to have the data written in the last cell automatically put that number into cell B5.


I appreciate any help given.

Sopman

 

[SkipVought]

Hi,

[tt]
=COUNTA(A:A)
[/tt]
is how many rows of data you have in column A

Skip,

_[red][/red]

 

[Sopman]

Skip, I don't want to count. I never know how many rows of data I have and the last row of data I need to copy to B5.

Sopman

 

[AnotherHiggins]

That's why you count - to see which row is the last row.

Put this in B5:
[COLOR=blue white]=OFFSET($A$1,COUNTA($A:$A)-1,0,1,1)[/color]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[Sopman]

Thank You. I'm still a rookie with these formulas.
That line worked great.

Sopman