No, Bob, I didn't explain myself well. If you have two colomns of data,
column A containing date values, and column B containing a lookup
formula, what formula can you use to find the last cell in column B
that contains a value, bearing in mind that there will be gaps in
column B (corresponding to the weekends)

Hope that's clearer.


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=504327