|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 29th, 2005, 08:39 PM
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
December 29th, 2005, 08:54 PM
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
December 29th, 2005, 09:57 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How To Change default error messages | Rich1234 | Using Forms | 7 | March 28th, 2006 12:54 AM |
| Look Up and Display set data | timharding | General Discussion | 0 | August 10th, 2005 08:31 PM |
| Calendar Question | Josh | General Discussion | 7 | March 28th, 2005 11:19 PM |
| Outlook Contacts Display as | [email protected] | Contacts | 0 | February 11th, 2005 07:27 PM |
| Undersize window display on monitor | FRED | Worksheet Functions | 0 | September 26th, 2003 07:05 PM |
Linear Mode
