Last Cell Return

S

sunroyal

Is there a way for me to have a list that returns the last (or bottom)
row of cells to a fixed row or column at the top of a worksheet. For
example:


Jim Wells 546-789-4848
bill Jones 787-585-4826
bob haslet 215-556-4825

As the above list accumulates, I would like to have the last entry,
(in this case Bob Haslet) to always be present at the top of the
worksheet, and change evry time a I add a new contact.

Can this be done?


Lane
 
J

Jason Morin

Very creative, Peo! I like it.

Jason
-----Original Message-----
One way

=LOOKUP(REPT("z",255),A2:A10000)

where A would hold your names

--

Regards,

Peo Sjoblom





.
Click to expand...
 
S

sunroyal

can anyone tell me if this is possible if the cell contains times o
numbers? I need to have it do times especially. Thank
 
P

Peo Sjoblom

What is possible? Get a clue and quote from the post you are referring to!
Excel dates = numbers
 
S

sunroyal

i was try ing to figure out how to get this particular formula:

=INDEX(A:A,COUNTA(A:A))

or this one:

=LOOKUP(REPT("z",255),A2:A10000)

to recognize time formatted cells that have a h:mm:ss value.

I hope thats clearer, I've spent the last two hours with my kid al
over me, I was a little vague, sorry.

Lan
 
Top