Index data
 

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

Index data
 

=sumif(A:A,"EH52212995",H:H)/Countif(A:A,"EH52212995")

--
Regards,
Tom Ogilvy


"Jeanette" wrote in message
...
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

Index data
 

I would still have to write an expression for each row, does excel have the
capabilities of distinguishing unique values independently? for excample each
EH is unique number assisgned to a client, I'm am trying to track the days to
process for each EH, not each group of procedures (multiples of the same EH)

"Tom Ogilvy" wrote:

=sumif(A:A,"EH52212995",H:H)/Countif(A:A,"EH52212995")

--
Regards,
Tom Ogilvy


"Jeanette" wrote in message
...
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