last item in a column

Thanks:  0
Likes:  0

# Thread: last item in a column

1. ## last item in a column

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?

2. text or numerical?

3. ## Re: last item in a column

Originally Posted by 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?

Is it text or numeric?

4. an example...

******** ******************** ************************************************************************>
 Microsoft Excel - Book5 ___Running: xl2002 XP : OS = Windows XP
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 B2C2 =

A
B
C
D
1
5last numberlast text
2
42a
3
6
4
pop
5
lol
6
7
7
4
8
2
9
a
 Sheet1

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

text formula is:

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

numerical formula is:

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

5. ## Re: last item in a column

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

6. ## Re: last item in a column

Originally Posted by Brian from Maui
Originally Posted by 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?

Is it text or numeric?

7. ## Re: last item in a column

thanks again!

8. you're very welcome!

9. ## Re: last item in a column

Originally Posted by Caius

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

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

=LASTROW(G:G)

10. ## Re: last item in a column

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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•