Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to utilize "COUNTIFS" to return a count of unique values
In the example below I need to return a count of column "B" data "Garcia,
Deborah", "HARRIS, CHARMAINE", "SEIBLY, RONALD" only where the data in column "A" is unique to the same data in column "B". (Repetative values in column "A" being counted only once per data in column "B". I need the below example to return a count of 2 each for "Garcia, Deborah", "HARRIS, CHARMAINE" and ""SEIBLY, RONALD". Complicating this calculation is the fact that two of the agents in column "B" touched the same contact in column "A", note the same contact_ID. Is this possible? A B C contact_id Completed By description 20LNWTGITX GARCIA, DEBORAH Indirect Confirmation 20LNWTGITX GARCIA, DEBORAH No Confirmation Made B21T9A55B1 GARCIA, DEBORAH Direct Confirmation WVYLBERITX HARRIS, CHARMAINE No Confirmation Made WVYLBERITX HARRIS, CHARMAINE No Confirmation Made BQFWA3AEM1 HARRIS, CHARMAINE Voicemail Confirmation 20LNWTGITX SEIBLY, RONALD Indirect Confirmation 20LNWTGITX SEIBLY, RONALD No Confirmation Made 34V75WIITX SEIBLY, RONALD Direct Confirmation |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to utilize "COUNTIFS" to return a count of unique values
With data from A2 to C10 with no blank rows try the below formula...You can
reference the name to a cell..Please note that this is an array formula. You create array formulas in the same way that you create other formulas, except you press CTRL+SHIFT+ENTER to enter the formula. If successful in 'Formula Bar' you can notice the curly braces at both ends like "{=<formula}" =SUM(N(FREQUENCY(IF((B2:B10="Garcia, deborah"),MATCH(A2:A10,A2:A10,)),MATCH(A2:A10,A2:A 10,))0)) If this post helps click Yes --------------- Jacob Skaria "ascottbag-hcm" wrote: In the example below I need to return a count of column "B" data "Garcia, Deborah", "HARRIS, CHARMAINE", "SEIBLY, RONALD" only where the data in column "A" is unique to the same data in column "B". (Repetative values in column "A" being counted only once per data in column "B". I need the below example to return a count of 2 each for "Garcia, Deborah", "HARRIS, CHARMAINE" and ""SEIBLY, RONALD". Complicating this calculation is the fact that two of the agents in column "B" touched the same contact in column "A", note the same contact_ID. Is this possible? A B C contact_id Completed By description 20LNWTGITX GARCIA, DEBORAH Indirect Confirmation 20LNWTGITX GARCIA, DEBORAH No Confirmation Made B21T9A55B1 GARCIA, DEBORAH Direct Confirmation WVYLBERITX HARRIS, CHARMAINE No Confirmation Made WVYLBERITX HARRIS, CHARMAINE No Confirmation Made BQFWA3AEM1 HARRIS, CHARMAINE Voicemail Confirmation 20LNWTGITX SEIBLY, RONALD Indirect Confirmation 20LNWTGITX SEIBLY, RONALD No Confirmation Made 34V75WIITX SEIBLY, RONALD Direct Confirmation |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can COUNTIFS be utilized to return unique values? | Excel Worksheet Functions | |||
Can "countifs" be utilized to return a count of unique values? | Excel Worksheet Functions | |||
Can "COUNTIFS" be utilized to return unique values? | Excel Worksheet Functions | |||
"--" (was "DCOUNT Unique Values") | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |