last item in a column

[Caius]

Hi there, it's me again, Excel n00b.

Just wondering if there's a formula for retrieving the last item in a column and then storing that value into another cell?

 

[Zack Barresse]

text or numerical?

 

[Brian from Maui]

Hi there, it's me again, Excel n00b.

Just wondering if there's a formula for retrieving the last item in a column and then storing that value into another cell?

Is it text or numeric?

 

[Zack Barresse]

an example...

Book5
	A	B	C	D
1	5	lastnumber	lasttext
2	4	2	a
3	6
4	pop
5	lol
6	7
7	4
8	2
9	a
Sheet1

text formula is:

=VLOOKUP(REPT("z",255),A:A,1)

numerical formula is:

=VLOOKUP(9.99999999E+307,A:A,1)

 

[Caius]

Hot **** you guys are fast. I sure hope you're getting paid to answer these questions. If you're not, you should be!

 

[Zack Barresse]

Hi there, it's me again, Excel n00b.

Just wondering if there's a formula for retrieving the last item in a column and then storing that value into another cell?

Is it text or numeric?

 

[Caius]

Oh, and to answer your question it was text.

thanks again!

 

[Zack Barresse]

you're very welcome!

 

[Brian from Maui]

Oh, and to answer your question it was text.

thanks again!

=INDEX(G:G,MATCH(REPT("z",255),!G:G))

=LOOKUP(REPT("z",255),G:G)

Using the Morefunc addin

=LASTROW(G:G)

 

[njws]

Using firefytr's formula is there a way to return the second to last value? I'm specifically interested in the numeric version.

Ultimate goal: Return the last value, the second to last value, and the change between the two.