Return last number in a column?? 1

[FYRGUY47]

I think this is an easy one, however I can't seen to find it the formula.... (

Using Excel 2003, also using Excel 08 for Mac, I would like to have a cell (D3) return the last number in a column (B)

I hope this is enough information for you. Thank you in advance for your help on this one....

Chris

 

[Kurupt55]

Assuming your data starts in cell B1 use this formula =INDIRECT(CONCATENATE("C",COUNT(C:C)))
otherwise use this
=INDIRECT(CONCATENATE("C",COUNT(C:C)+X))
where X is the number of empty cells above your list of data.

Hope this helps

Impossible is Nothing

 

[FYRGUY47]

That worked!! Thank you!

I would have never figured that one out, it was not what I thought it would be.

Thanks again!
Chris

 

[Kurupt55]

no problem
meant to put B in the formula instead of C, but looks like you figured it out.

Impossible is Nothing

 

[SkipVought]

Yet another way...
[tt]
=INDEX(A:A,NbrEmptyCells+COUNTA(A:A),1)
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

oops, you did say column B
[tt]
=INDEX(B:B,NbrEmptyCells+COUNTA(B:B),1)
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}