Thanks BenjieLop for your reply & formula. It worked great!

Can you tell me how would I average all the daily _work_ miles if all
the destinations have different names?

michaelas


--
michaelas
------------------------------------------------------------------------
michaelas's Profile: http://www.excelforum.com/member.php...o&userid=26573
View this thread: http://www.excelforum.com/showthread...hreadid=466654