#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Hello? Anyone out there?!?!?
PLEASE HELP ME!!!!
I'm still waiting for someone to help me on this. |
#3
|
|||
|
|||
Did I do something wrong?
Am I not using this forum corectly?
Is there no solution to my question? I don't know where else to go for this. PLEASE PLEASE SOMEONE OUT THERE HELP ME!! PLEASE!!!!! I'm using =LOOKUP(999999,A13:A84) for finding the most recent entered Date in a list of dates. In cell A100 is the =LOOKUP(999999,A13:A84) formula. This formula is giving me the contents of cell A72. I need a way to change the resulting cell to A71 instead of A72. There MUST be a way to have Excel subtract the resulting cell by one. |
|
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 |