Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Repeat Call Calculation

0

Hi Team, 

I have a problem, I have a data set of an average of 5k records, 3 key important columns Column A has Agent Name, Column B has Average handle Time and Column c has customer number.

I want to calculate the repeat call for each agent based on how many times customer of the same number called in.

can i get help with this?

excel
MS Office Version: 2010
posted by: Sam Lee (rep: 2) on Fri Jul 12, 2019 at 3:37 am
Answer
Discuss

Discussion

Hi Sam, You "want to calculate the repeat call for each agent based on how many times a customer called". Not clear. How to "calculate the repeat call"? In fact, what is a "repeat call"? It would seem that you want not an extra column in your existing sheet but a table on another tab. If you would post a workbook with and abbreviated data sheet and the design of the output table (perhaps with a few results manually filled in for demonstration) your requirement would become clear.
Variatus (rep: 4889) Jul 12, '19 at 5:16 am
Hi Variatus, 

have attached a sample of the raw file, the columns that will use to calculate is Column F which is agent Name, column I call duration and column K which is customer number. hope this helps 
Sam Lee (rep: 2) Jul 12, '19 at 8:50 am
Add to Discussion

Answers

0

Your question isn't clear because you don't specify an output location or output format. However, the formula below might help you.

=SUMPRODUCT(--($F$2:$F$100=$F2),--($K$2:$K$100=$K2),--($I$2:$I$100))

Paste it into cell N2 of your sample worksheet and copy down. The formula returns the exact same values from column I. Now copy K2 to K13, creating a duplicate of that number being called by the same agent. Both N2 and N13 reflect the change.

posted by: Variatus (rep: 4889) on Fri Jul 12, 2019 at 9:34 pm
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login