michaelas Wrote:
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

Just change the "rec" in the formula with the destination of your
choice. I hope I understood your question correctly.

Regards.


--
BenjieLop


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