 |
 | 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 / February 2008Is there a formula for "last"
I have a lookup cell that compares today's value with that of a week ago. But sometimes (like on weekends) the today value doesn't change. Is there a formula for "last"? i.e., instead of TODAY() is there a LAST() formula? Thanks. Butch This formula will return the *last* numeric value entered in column A: =LOOKUP(1E100,A:A)  SignatureBiff Microsoft Excel MVP >I have a lookup cell that compares today's value with that of a week ago. >But sometimes (like on weekends) the today value doesn't change. Is there >a formula for "last"? i.e., instead of TODAY() is there a LAST() >formula? > > Thanks. Butch Like as in eschatology? >I have a lookup cell that compares today's value with that of a week ago. >But sometimes (like on weekends) the today value doesn't change. Is there >a formula for "last"? i.e., instead of TODAY() is there a LAST() >formula? > >Thanks. Butch |
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.