| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transposing data with Index function | Excel Worksheet Functions | |||
| trying to use the index function when #N/A can be part of data ran | Excel Worksheet Functions | |||
| INDEX and Scanning a Data Set in Excel | Excel Worksheet Functions | |||
| Using INDEX() to Locate Variable Data | Excel Discussion (Misc queries) | |||
| How do I "index" data in a line graph? | Charts and Charting in Excel | |||
Hybrid Mode
