All,
I have the following type of data:
Part1
{"PROSPECT_NO","CREATION_DATE","STATE_CODE","PAY_METHOD","CONTRACT_TYPE","TITLE","FIRST_NAME","SURNAME","ADDRESS","AGBNT_ID","AGNET_NAME","CANCELLATION_DATE","CANCELLATION_REASON","HOW_THEY_CANCELLED";"SDTS0060036104",37274,"CANC","MDD","GAS","Mrs","Jane","Doe","2 Mystery Way, KT3 5ED","SIT00005","AGENT1",37280,"No reason given","Letter";"SDTS0060037925",37279,"CANC",0,"ELEC","Mr & Mrs","S","Madeup","12 Nowhere Street, TW135HY","SIT00008","AGENT2",37281,"Info only","Inbound call";"SDTS0060037925",37279,"CANC",0,"GAS","Mr & Mrs","S","Madeup","12 Nowhere Street, TW135HY","SIT00008","AGENT2",37281,"Info only","Inbound call";"SDTS0060037626",37278,"CANC","MDD","GAS","Mr","STEPHEN","NOT","76 As Above, OZ12 9SS","SIT00009","AGENT3",37281,"Customer changed mind","Inbound call"}
Part2
{"SDTS0060037412",37277,"CANC",0,"ELEC","Mr & Mrs","E","YOU","5 My Lane, ZZ26ZZ","SIT00008","AGENT4",37281,"Info only","Welcome call";"SDTS0060037412",37277,"CANC",0,"GAS","Mr & Mrs","E","YOU","5 My Lane, ZZ26ZZ","SIT00008","AGENT4",37281,"Info only","Welcome call";"SDTS0060042877",37279,"CANC",0,"ELEC","Mrs","IAN","MAC","13 Nearly There, NT104AR","SIT00008","AGENT2",37284,"Customer changed mind","Inbound call";"SDTS0060042877",37279,"CANC",0,"GAS","Mrs","IAN","MAC","13 Nearly There, NT104AR","SIT00008","AGENT2",37284,"Customer changed mind","Inbound call";"SDTS0060038094",37280,"CANC",0,"ELEC","Mrs","COMEON","EILEEN","63 Back Lane, BB5 3BB","SIT00001","AGENT1",37285,"Wants to remain with existing supplier","Inbound call"}
What I'd like is to have a formula that will count the entries using certain criteria BUT only unique Entries
SO, example expected results would be:
All Cancellations by agent2 = 2
All Cancellations on or before Jan 24 = 4
Any ideas??
I have the following type of data:
Part1
{"PROSPECT_NO","CREATION_DATE","STATE_CODE","PAY_METHOD","CONTRACT_TYPE","TITLE","FIRST_NAME","SURNAME","ADDRESS","AGBNT_ID","AGNET_NAME","CANCELLATION_DATE","CANCELLATION_REASON","HOW_THEY_CANCELLED";"SDTS0060036104",37274,"CANC","MDD","GAS","Mrs","Jane","Doe","2 Mystery Way, KT3 5ED","SIT00005","AGENT1",37280,"No reason given","Letter";"SDTS0060037925",37279,"CANC",0,"ELEC","Mr & Mrs","S","Madeup","12 Nowhere Street, TW135HY","SIT00008","AGENT2",37281,"Info only","Inbound call";"SDTS0060037925",37279,"CANC",0,"GAS","Mr & Mrs","S","Madeup","12 Nowhere Street, TW135HY","SIT00008","AGENT2",37281,"Info only","Inbound call";"SDTS0060037626",37278,"CANC","MDD","GAS","Mr","STEPHEN","NOT","76 As Above, OZ12 9SS","SIT00009","AGENT3",37281,"Customer changed mind","Inbound call"}
Part2
{"SDTS0060037412",37277,"CANC",0,"ELEC","Mr & Mrs","E","YOU","5 My Lane, ZZ26ZZ","SIT00008","AGENT4",37281,"Info only","Welcome call";"SDTS0060037412",37277,"CANC",0,"GAS","Mr & Mrs","E","YOU","5 My Lane, ZZ26ZZ","SIT00008","AGENT4",37281,"Info only","Welcome call";"SDTS0060042877",37279,"CANC",0,"ELEC","Mrs","IAN","MAC","13 Nearly There, NT104AR","SIT00008","AGENT2",37284,"Customer changed mind","Inbound call";"SDTS0060042877",37279,"CANC",0,"GAS","Mrs","IAN","MAC","13 Nearly There, NT104AR","SIT00008","AGENT2",37284,"Customer changed mind","Inbound call";"SDTS0060038094",37280,"CANC",0,"ELEC","Mrs","COMEON","EILEEN","63 Back Lane, BB5 3BB","SIT00001","AGENT1",37285,"Wants to remain with existing supplier","Inbound call"}
What I'd like is to have a formula that will count the entries using certain criteria BUT only unique Entries
SO, example expected results would be:
All Cancellations by agent2 = 2
All Cancellations on or before Jan 24 = 4
Any ideas??