|
|
#1
09-05-2008, 03:31 PM
|
|||
|
|||
Using the LOOKUP Command
I'm using =LOOKUP(999999,A13:A84) for finding the most recent entered Date in a list of dates. Is there a way to modify the line so that it will select the cell prior to the one the current code finds. Eg: Curently the code spits out the contents of cell A72. I'd lile it to spit out the contents of cell A71. Thanks in advance. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Add-In:How to add command right click command bar | phang | Outlook | 0 | 01-15-2007 02:53 AM |
| Help with Max or lookup fomula to return a name forAmaxValue | dutch4fire23 | Excel | 0 | 07-28-2006 01:12 PM |
| command buttons | ronf | Excel | 0 | 04-28-2006 08:32 AM |
| command buttons | ronf | Excel | 0 | 12-03-2005 06:26 AM |
Using the LOOKUP Command
Threaded Mode