# A2-A14=100%: Number Of Calls Column, With Number Of Calls

Jan 18, 2009

I have Problem column, with problems from A2 to A14. I have number of calls column, with number of calls from B2 to B14 and finally i have percentage column in which i want to automatically calculate problems percentage. I'm including my exel file.

## Number Of Calls Made By A Person In A Month

Sep 5, 2013

The first column is "Person Name" and the second column is date in format "6/27/2013". I want a formula to calculate the total number of calls a person made in the month of June.

## How To Calculate A Number Of Calls Logged In A Shift

Jan 7, 2014

calculating the number of calls logged in a shift, based on a 3 shift system in a day. shift 1 from 08h00 to 16h00, shift 2 16h00 to 24h00, and shift 3 00h00 to 08h00. each shift receives a number of calls based on the time the call was submitted.

## Count Number Of Calls (C In The Rows) Of Each Provider?

Feb 13, 2012

Want to be able to count number of calls (C in the rows) of each provider by DOW (labels in the column).

## Get Median (and Average) Value Of Total Number Of Calls?

Apr 1, 2013

I have a team of 8 people who take calls. I need to get the median (and average) value of the total number of calls for these people for a specified date range, say 1/1/2013 to 1/24/2013.

When i use the following f(x):

{=MEDIAN(IF((Call_Data!\$A\$2:\$A\$13000>=\$E\$8)*(Call_Data!\$A\$2:\$A\$13000

## Sub Calls Sub Recup Value

May 22, 2007

I have two macros, Sub macro_Combs() calls Combin_6N()

In macro_Combs I must recover the values of the line in progress 500 step 28 to put them in vN(J) table of 10 élements.

The line in progress can go from 4 to 10 digits

if I make vN(J) = Sheets("feuil3").Cells(J).Value functions for 500 step 28 but with same the information of line 1 of feuil3

if I make vN(j)=cells(lig, col).value that does not function

Public lig As Integer
Public Col As Integer

>>>>1 ère macro

Sub macro_Combs()
For Lig = 1 To 100 Step 28
For Col = 1 To 1
Next..........

## One Macro Calls Many

Sep 30, 2009

I have this code (below) that calls a number of other subroutines. It begins the process just fine, but then gets hung up upon completing the first macro called, Run_Educator_Report. What could be causing this?

Sub Run_All()
Call Run_Educator_Report
Call Run_Non_Educator_Report
Call Construct_Database_for_Graphs
ActiveWorkbook.Save
End Sub

## Trying To Chart Calls Per Minute / Per Day

Dec 6, 2013

I'm trying to use some call data for some predictive staffing. I need to see the highest number of calls happening around the same time each day. I'll have to do this for a number of different lines, so working out a formula that could apply.

I have two columns, date and time stamps of the calls. A small sample is below.

7/1/13 5:50 AM
7/1/13 9:49 AM
7/1/13 10:33 AM
7/1/13 10:53 AM
7/1/13 11:19 AM
7/1/13 11:41 AM
7/1/13 12:07 PM
7/1/13 3:58 PM
7/1/13 4:03 PM
7/1/13 5:35 PM
7/1/13 6:27 PM
7/1/13 6:39 PM
7/1/13 7:37 PM

## Find Non Blank Calls

Nov 25, 2008

I need to create a formula that counts the number of blank cells to the right and then actually uses the value in the non blank cell.

The result requiired is that the formula will find the difference between 1 value, the next non blank cell and then will average the cells between to get the interval figures.

eg. Value1 is 50.
Value2(the next nonblank) is 60.
There are 4 empty cells in between.

I need a formula that will find the next Nonblank (Value2), calculate the difference between Value1 and Value2, then divide that by the number of blank cells + 1 and add the value to the left.

The cell in A2, calculated manually at the moment would be:
=A1+((A6-A1)/(4+1))
This would then be altered across the page so that A3 would be:
=A2+((A6-A2)/(3+1)

etc., etc.

Therefore the result returned across the blank cells would be:

A1 A2 A3 A4 A5 A6
Value1 BLANK BLANK BLANK BLANK Value2
50 52 54 56 58 60

## Count Hours Where Calls Are Received?

Jan 27, 2014

I am trying to count hours where calls are received between 8am and 5pm Mon-Fri. If just one call is received between 8am and 5pm Mon-Fri then only one hour would be counted. Calls in excess of one call in the same hour do not count more than one. So if two people called from 8am - 9am then that would equal 1 and if on call came in from 9-10 then that would also be 1. Attached is a sample output.

## Automatic Phone Calls From A Spreadsheet

Aug 17, 2009

Is there anyway to make phone calls automaticly from a spread sheet

I'm calling old customers and it would be easy to just press a button and it will dial for me

## Share A Toolbar That Calls Macro From An Add-in

Mar 14, 2008

I have created some macros that need to be used in several workbooks by more than one users, so I put them in an add-in and gave them instructions on how to get the add-in. I also created a toolbar with buttons calling those macros, attached it to a workbook the users can open, and instructed them to open that workbook once to get the toolbar.

Both the add-in and the toolbar workbook are on a network drive that my users can access, but when they get the add-in, it gets copied to their own add-in folder.

Here's my problem:
When a user tries to click on one of the buttons in the toolbar, the button tries to call the macro using the path that would be valid on my computer to get to my add-in folder. This path includes my user name, so it doesn't go to their own add-in folder: it goes to my add-in folder on that computer if I ever logged in on that particular machine, or it goes nowhere.

When I created the button, I attached the macros by referring to the add-in workbook by name only, without referring to a path, so I don't know why MY path ended up defined on that toolbar.

How can I go around this? I manually relinked all the buttons for that user, and I can do it for the other users (there aren't that many users nor that many buttons), but I'd rather avoid it: I'll have to re-do it if the toolbar is updated and it just seems like more work than should be necessary.

I'm also opened to suggestions on a better way to share those macros. They can't be attached to the workbooks because we use new workbooks every year - they're emailed to us by the people who create them and for a variety of reasons, pasting everything into a workbook of our own is not a good option.

## Sequential Lookup Calls In One Cell

Aug 27, 2012

I'm updating someone's spreadsheet and so don't won't to add new cells or anything to it if possible. The problem I have is that I need to perform hlookup's of 3 cells, average them (some responses are non numeric) and then hlookup the output to give a final value.

The problem I have is that putting the lookups in one cell and then averaging them and looking up the average in another works, but all three steps in cell won't, it keeps choking on the non numeric responses.

Are their any work arounds to this, as the sheet has quite a bit of VBA code attached and I don't really want to have to add columns and then change the VBA code too.

## Concurrent Calls With Start And End Time?

Nov 23, 2012

I have a set of call data including start time and end time, with all calls on the same date. Now, how would I show in a sepearate column the concurrent calls being made. i.e how many calls are being used at the same time. This relates to how many channels I can suggest to someone with the maximum concurrent calls being made.

I have attached someConcurrent CaConcurrent Calls sample.xlsxsample.xlsx sample data.

## User Form Event Calls

Jun 1, 2008

if you can prevent an event macro from running at will.

The problem is occuring when I have a userfrom with various controls, and the change of one control triggers an event macro that changes other controls, this then in turn triggers further control change macros.

I have tried altering the macro name to things like optionbutton1_change, select, enter etc.

The only other way around it I can think of is to introduce a binary variable, but that will mean ensuring it os always the right value and then coding an IF statement on each event macro.

Therefore, I'm thinking there must be an easier way, some kind of switch ??? Something that says ignore any event macro when the control is changed as a result of different event macro.

- I'll include a small example below just to clarify what I am talking about.

private sub optionbutton1_click()

userform1.textbox1.value = "Test Change"

end sub

private sub textbox1_change()

msgbox "Change taken place"

end sub

What I am trying to achieve is getting excel to ignore the second macro when the control is changed by another macro rather than a user entry.

## Macro To Transpose And Merge Calls Automatically?

Jun 19, 2014

I wonder is there a way that I can transpose and merge calls by using macro?

## Macro Calls A Unwanted Procedure During Runtime

Jan 14, 2010

I have a VBA application in Excel.
In a certain time, when the code is executed in the

Private Sub CB_ValidaHoras_Click()

## Creating Main Menu On Userform Using API Calls

Jun 17, 2011

I am trying to create a "mainmenu". On a Userform using API calls.

Created a Userform and named it Form1.

Added a command button to the form and named it Command1.

In THISWORKBOOK code:

Private Sub Workbook_Open()
Form1.Show
End Sub

[Code] .........

I open the file and Form1 is shown with its command button. When I click the command button I get an error:

Run-time error 49:

What is the correct convention?

## Count Occurrences Of Phone Calls Made?

Jul 3, 2012

Count number of occurrencesI have a large spreadsheet that list customer and call dates. Each call is displayed in a separate row with the corresponding customer next to it - so each customer may show up multiple times with different call times. I want an equation that will count if 4 calls (occurrences) have been made to each customer and if it is the answer is "1". I have been trying to make it working with COUNTIF but not getting the results.

## Managing Two Forms / One Form Calls Action From The Other

Jun 27, 2013

I`m making an Costumer Database for my business in excel, I already made a form in witch I can insert, change or exclude a client. In this form I have a button that hides the actual form and show another one to perform the search.

The search is working fine with the listbox, what I need right now is that i can search someone and then I click on the client i want in the listbox and somehow get the reference and open the other form with that reference.

The first form work with an reference number that is defined as a variant, so i have a macro that see this number and bring the client with that code. In the other form I needed a macro that gets the value of the selected reference in the listbox, then hide the form, call the other one and run a private sub.

## Retain OptionButton Choice Between UserForm Calls

Feb 6, 2008

I have two option buttons on a userform and when the user selects an option button I would like it to stay selected when the userform is called again.

## Using *.xls As Part Of A Loop: Skips The First Sub And Automatically Calls The PerthLocation Sub

Apr 15, 2009

I'm writing something similar to an auditing tool. I get a list of files from a pre determined directory. All these files are then listed on the spreadsheet. However, there is one file which has a different layout to the 88 other ones. I've written 2 subs (NonPerthLocation for the 88 stores, and PerthLocation for the 1 different sheet.) I'm trying to write a loop like the one below, however it skips the first sub and automatically calls the PerthLocation sub. In short, basically if the file has Loc 089 in any part of the filename, I want it to run the PerthLocation sub.

## Pivot Charts - Override What Legends Calls Particular Lines

Mar 20, 2012

I am using some Pivot charts, but I want to override what legends calls particular lines. Is there any way to control what legend says?

## Find The Median Call Length For Calls In A Certain Month

Dec 13, 2006

I've read several threads about using Median(If, and I have success with one criteria, but not with three. Here's the setup:

I have a log of phone calls, and I want to find the median call length for calls in a certain month or set of months (i.e. a quarter, three months). In Calls!B I have the date of the call, in Calls!C I have the call length in minutes (i.e. "34"), and in Calls!A I'm using Concatenate and Text to return month/year (i.e. "Aug06").

With one criteria, it calculates the median correctly. With three, it only returns #NUM. Yes, I hold control+shift and hit enter. Here's my formula:

=MEDIAN(IF(Calls!\$A\$2:\$A\$500=Scores!B8,IF(Calls!\$A\$2:\$A\$500=Scores!C8,IF(Calls!\$A\$2:\$A\$500=Scores!D8,Calls!\$C\$2:\$C\$500)))))
Where Scores!B8,C8,D8 hold "Oct06" "Nov06" and "Dec06" respectively. What am I doing wrong? Is there another approach I should use instead?

## Calculate The Weighted Average Of The Win Rate Based On Volume Of Calls

Nov 23, 2009

I have 3 sets of data for two different groups:

Group 1 - Inbound
- Total volume
- Win rate (gross adds/total volume)

Group 2 - Outbound
- Total volume
- Win rate (gross adds/total volume)

I need to calculate the weighted average of the win rate based on volume of calls. Is there any way to do that?

## Count Number Of Clusters / Groups Of Given Number Occurs In Column

Mar 2, 2012

I have data in a column (G) consisting of zero and ones. I would like to count the number of clusters of the number 1 in the data. For example in the data below there are 8 ones. But instead, I need to calculate how many groups of 1s occur. So in the case below the group of 1s = 3.

In terms of what defines a group. Whenever there is a zero either before or after the occurance of a 1 constitues a group, i.e the groups are broken out by zeros.

0
0
0
0
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
1
1
1
1
0
0
0
0
0
0
1
0
0

## Rounding Number And Then Shrinking Number Of Digits To Fit With Narrow Column

Feb 6, 2013

I have a number, eg, 1234567 and rounded to prepare the shrink of the size of the number like

= Round(a1, -3). I have, say now, 1234000.

I need to strip "000" from the number and place 1234 to a cell.

## Carrying Over Negative Number To Next Column As Positive Number?

Aug 21, 2014

I go negative in one column I want it to show up in the next column as a positive number because when I add my income and subtract my bills and the negative from last month to get the what cash I'll have left it screws up because negative subtract a negative is a positive. So how do i get the sum of say B9 to from -\$5.00 to +\$5.00 into C4 so when i subtract C4 From my income it wont add to it.

## VBA To Number Rows In A Column But Starting From Specific Number

Mar 10, 2014

I would like to create a vba script when ran an input.box comes up and asks you to "enter number you want to start numbering from" and when the number is entered in the input box. e.g "7654", excel starts numbering each cell in column A from 7654 until there is an empty cell in column B.

## Find Cell Value Row Number & Use For Column Number

Jun 2, 2008

to update these values via a form in this sheet. I can find the correct row to be edited by entering a value from column A and B. The problem is if I want display the values of that row first and then change it. If I want to change row 10 data how can I bring back the value in ROW 3 AND THE COLUMN VALUE? The next step would be to do the actual update if I want to change ROW 10 to "Ooi" and a sales value of 200?

This is what I have done so far:

Dim myRows As Integer

With Sheets("Mrt")

'Retrieve history information for row
For myRows = 4 To 49
If comboxDay.Text = Range("A" & myRows).Value And textboxdescription.Text = Range("B" & myRows).Value Then
textboxbedrag.Text = Range("C" & myRows).Value
chkBTW_Ja.Value = Range("D" & myRows).Value
txtNota.Text = Range("S" & myRows).Value
End If
Next
End With

Picture attached to show how sheet looks like.