How do I create a formula that only brings back the number of days for each
unique Accession number? For instance, Accession #EH52212995 took 1 day to
process, but there were three different test ran, I only need to know that it
took one day. HELP.


Accession Unit Code MColDt Collect Date MRecDt Received Date Report
Date "Days to
Process"
EH52212995 74000 60082 7/1/2005 38534 7/1/2005 7/2/2005 1
EH52212995 74000 60082 7/1/2005 38534 7/1/2005 7/2/2005 1
EH52212995 74000 60082 7/1/2005 38534 7/1/2005 7/2/2005 1
EH52212369 74000 60082 7/1/2005 38534 7/1/2005 7/2/2005 1
EH52213071 74000 60082 7/1/2005 38534 7/1/2005 7/2/2005 1
EH52214944 74000 60082 7/1/2005 38538 7/5/2005 7/7/2005 2
EH52215164 74000 60082 7/1/2005 38538 7/5/2005 7/7/2005 2
EH52216199 74000 60082 7/1/2005 38539 7/6/2005 7/8/2005 2
EH52216199 74000 60082 7/1/2005 38539 7/6/2005 7/8/2005 2
EH52216199 74000 60082 7/1/2005 38539 7/6/2005 7/8/2005 2
EH52216199 74000 60082 7/1/2005 38539 7/6/2005 7/8/2005 2
EH52213894 74000 60082 7/1/2005 38535 7/2/2005 7/5/2005 3
EH52214022 74000 60082 7/1/2005 38535 7/2/2005 7/5/2005 3
EH52213811 74000 60082 7/1/2005 38535 7/2/2005 7/5/2005 3