How about a bout a Pivot table with the clinic on the left axis, the
sales reps acros the top, and MAX of the dates in the field?

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=527855