Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Display last row entered
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: http://www.excelforum.com/member.php...fo&userid=8453 View this thread: http://www.excelforum.com/showthread...hreadid=496781 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Display last row entered
From 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("z",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("z",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("z",255),Sheet1!A:A),A:A) ) You can miss out the "Sheet1!" 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 "tallpaul" wrote in message ... 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: http://www.excelforum.com/member.php...fo&userid=8453 View this thread: http://www.excelforum.com/showthread...hreadid=496781 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Display last row entered
Thanks for the prompt reply, not only prompt but exactly what I needed. Cheers Paul. -- tallpaul ------------------------------------------------------------------------ tallpaul's Profile: http://www.excelforum.com/member.php...fo&userid=8453 View this thread: http://www.excelforum.com/showthread...hreadid=496781 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I don't want to display any controls in excel. | Excel Discussion (Misc queries) | |||
Formula is entered but will not display result | Excel Worksheet Functions | |||
Look Up and Display set data | Excel Discussion (Misc queries) | |||
How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |