raymaster98
Board Regular
- Joined
- Oct 28, 2009
- Messages
- 212
In Excel 2003, I am using the following formula to return a time:
{=OFFSET(INDEX(BW5:BW24,MATCH(TRUE,BW5:BW24<>"",0)),0,-5)}
I need to modify the above formula to look for the first non blank cell above that point. Any help would be most appreciated. Thanks, Kenny
{=OFFSET(INDEX(BW5:BW24,MATCH(TRUE,BW5:BW24<>"",0)),0,-5)}
I need to modify the above formula to look for the first non blank cell above that point. Any help would be most appreciated. Thanks, Kenny