New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Counting repeat calls

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Counting repeat calls

Postby Satyasony » Wed Mar 30, 2016 7:06 am

Hi All,

I'm pretty new to Excel. What I'm trying to do is count the number of times a person calls in a span of 3 days.

I have attached the sample excel file.

And same exercise I want to do with a month & 3 months data, I wanted to calculate

- How many customer called with in 3 days with %
- How many customers called with in 7 days with %
- How many times customer called in the same day.


Regards,
Satya
  • 0

You do not have the required permissions to view the files attached to this post.
Satyasony
Rookie
 
Posts: 2
Joined: Mar 30, 2016
Reputation: 0
Excel Version: 2013

Re: Counting repeat calls

Postby Satyasony » Fri Apr 01, 2016 5:12 am

Is there anyone to help ?
  • 0

Satyasony
Rookie
 
Posts: 2
Joined: Mar 30, 2016
Reputation: 0
Excel Version: 2013

Re: Counting repeat calls

Postby pecoflyer » Sun Apr 03, 2016 9:57 am

Hi and welcome to the boars

I can't help much for the moment not having XL here.

Did you try a Pivot Table?
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 81 guests