software

If I have a worksheet that is a series of text logs that ascend vertically
down and I want the last entered log to be displayed on another worksheet,
how do I do this??

If you mean the very last row in the sheet, you can use

=INDEX([Book2]Sheet1!$C$1:$C$19,MATCH(1,--(NOT(ISBLANK([Book2]Sheet1!$C$1:$C$19))),1))

This is an array formula, meaning you commit it by simultaneously pressing
Ctrl-Shift-Enter. Adjust it to reflect your workbook and worksheet names and
ranges

Note - it assumes there are no blank rows.

quot;Mistiquot; wrote:

gt; If I have a worksheet that is a series of text logs that ascend vertically
gt; down and I want the last entered log to be displayed on another worksheet,
gt; how do I do this??

Another way:

=LOOKUP(2,1/(Sheet1!A1:A20lt;gt;quot;quot;),Sheet1!A1:A20)

Biff

quot;Mistiquot; gt; wrote in message
...
gt; If I have a worksheet that is a series of text logs that ascend vertically
gt; down and I want the last entered log to be displayed on another worksheet,
gt; how do I do this??