 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006LAST PIECE OF DATA
How can I get a vlookup (or another function) to look for the DATA in the last row in of a column. For ex... have data in column A... rows 1-5 have data filled in. How can I get it to tell me what is in A5? And tomorrow when I fill in data in row 6, how can I get it to automatically report that data? just find a number or letter ("zzzzzz") larger possible =INDEX(A:A,MATCH(9999999,A:A),1)  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > How can I get a vlookup (or another function) to look for the DATA in > the last row in of a column. [quoted text clipped - 5 lines] > And tomorrow when I fill in data in row 6, how can I get it to > automatically report that data? Perfect, thanks > just find a number or letter ("zzzzzz") larger possible > =INDEX(A:A,MATCH(9999999,A:A),1) [quoted text clipped - 12 lines] > > And tomorrow when I fill in data in row 6, how can I get it to > > automatically report that data? Try this for alpha or numeric: =LOOKUP(2,1/(A1:A100<>""),A1:A100) SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > How can I get a vlookup (or another function) to look for the DATA in > the last row in of a column. [quoted text clipped - 5 lines] > And tomorrow when I fill in data in row 6, how can I get it to > automatically report that data? Several different formulas. =LOOKUP(9.99999999999999E+307,F:F) will return last numeric data in column F =LOOKUP(REPT("z",255),B2:B10000) will return last non-numeric data in column B =LOOKUP(2,1/(A1:A65516<>""),A1:A65516) will return last anything in column A Gord Dibben MS Excel MVP >How can I get a vlookup (or another function) to look for the DATA in >the last row in of a column. [quoted text clipped - 5 lines] >And tomorrow when I fill in data in row 6, how can I get it to >automatically report that data? > =LOOKUP(2,1/(A1:A65516<>""),A1:A65516) will return last anything in > column A Think that'll miss out what's possibly within A65517:A65535/6 <g>. Perhaps either: =LOOKUP(2,1/(A1:A65535<>""),A1:A65535) =LOOKUP(2,1/(A2:A65536<>""),A2:A65536) SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- Thanks Max 'Nother one of those typos. Gord >> =LOOKUP(2,1/(A1:A65516<>""),A1:A65516) will return last anything in >> column A >Think that'll miss out what's possibly within A65517:A65535/6 <g>. >Perhaps either: >=LOOKUP(2,1/(A1:A65535<>""),A1:A65535) >=LOOKUP(2,1/(A2:A65536<>""),A2:A65536) Gord Dibben MS Excel MVP Pleasure`, Gord ! SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Thanks Max > 'Nother one of those typos. > Gord
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.