software

Hi, on a large Spreadsheet, with Data added daily, I would like the last
row of Data added to display on Row 1 at A1, B1 etc. Please advise on
the best option, is it by using the Vlookup formula??
Cheers
Paul--
tallpaul
------------------------------------------------------------------------
tallpaul's Profile: www.excelforum.com/member.php...foamp;userid=8453
View this thread: www.excelforum.com/showthread...hreadid=496781From my notes copied from another message I know that:
=LOOKUP(9.99999999999999E 307,Sheet1!A:A) will return the last numeric value
of Sheet1 column A
=LOOKUP(REPT(quot;zquot;,255),Sheet1!A:A) will return the last text entry of Sheet1
column A
So if the data in the column is numeric use
=MATCH(LOOKUP(9.99999999999999E 307,Sheet1!A:A),A: A) to show the row number,
and if textual use =MATCH(LOOKUP(REPT(quot;zquot;,255),Sheet1!A:A),A:A)
If the last entry could be either text or number use
=MAX(MATCH(LOOKUP(9.99999999999999E 307,Sheet1!A:A ),A:A),MATCH(LOOKUP(REPT(quot;zquot;,255),Sheet1!A:A),A:A) )
You can miss out the quot;Sheet1!quot; stuff if the formulas are in the same
worksheet as the data.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;tallpaulquot; gt; wrote in
message ...
gt;
gt; Hi, on a large Spreadsheet, with Data added daily, I would like the last
gt; row of Data added to display on Row 1 at A1, B1 etc. Please advise on
gt; the best option, is it by using the Vlookup formula??
gt; Cheers
gt; Paul
gt;
gt;
gt; --
gt; tallpaul
gt; ------------------------------------------------------------------------
gt; tallpaul's Profile:
gt; www.excelforum.com/member.php...foamp;userid=8453
gt; View this thread: www.excelforum.com/showthread...hreadid=496781
gt;

Thanks for the prompt reply, not only prompt but exactly what I needed.
Cheers
Paul.--
tallpaul
------------------------------------------------------------------------
tallpaul's Profile: www.excelforum.com/member.php...foamp;userid=8453
View this thread: www.excelforum.com/showthread...hreadid=496781