monthly

Hi, I have monthly sales data for two products arranged as follows: Column A: Consecutive month-end dates (e.g. 31/12/2018, 31/01/2019, 28/02/2019 etc) Column B: Monthly sales values for Product A Column C: Monthly sales values for Product B I would like to create a formula that will...

Dear Excel community To start with, I am an Excel novice - please forgive me any naive questions. Context Column A contains dates in ascending order - each row for a new day. Cell C1 contains a variable as text string, which can either be "weekly", "fortnightly", or "monthly". Problem...

Hi - I have a number of tabs detailing team results in month order Jan in A2 Feb in B2 etc Then an on another tab I have the monthly results in month order team 1 team 2 team 3 etc for Jan in Cells A2 B2 C2 etc However each month I have to copy the formulae into the monthly results tab or...

Hi, I am pricing 2 extended warranty agreements. The warranties have a upfront price but the customer wants to pay for each warranty as monthly payment over 3 years/36 months. Extended Warranty A; qty 700; $2,000.00 Extended Warranty B; qty 30; $2,100.00 Because the warranties have...

Hello, I have a large spread sheet that lists multiple currencyvalues. For each value there is anassociated daily fee, weekly fee, and monthly fee. For example: <tbody> Value Daily Rate Weekly Rate Monthly Rate Value Daily Rate Weekly Rate Monthly Rate Value Daily Rate...

Hello, I have a large spread sheet that lists multiplevalues. For each value there is anassociated daily fee, weekly fee, and monthly fee. For example: In a separate location I want to be able to populate the dailyfee, weekly fee, and monthly fee for the specific value that I enter into...

Hi To all the experts I am desperately seeking an excel formula that would accurately calculate a monthly commission based on the following crtiteria: <tbody> Monthly Revenue Percentage Monthly Remuneration $83,333.33 0.00% $0 $166,666.67 1.00% $833 $250,000.00 1.25% $1,042...

Hi, Using Excel 2016, I have a yearly workbook that is broken in to months, quarters, and year-to-date worksheets. At the start of each fiscal year (April to March), I want to give the user the ability to clear all of their data entries in the entire workbook at the click of a single...

Hi Everyone, First off I wanted to thank everyone for the forum... This place is awesome.. I am learning a lot thanks to all you guys!!! I have monthly returns and wanted to calculate a 3 & 5 Year annualized return. Could anyone help me? Please see attached 31-Jan-14 0.71 28-Feb-14...

HI am building a dashboard where I want to highlight the monthly values for when the selected customer was part of a program. I have multiple years with monthly data, current and then some future months. The criteria I want conditional formatting to highlight yellow or TRUE in each monthly...

I am trying to use the DoCmd.OutputTo function to output to a file based on the values in a text box. Here is what I'm using: Do.Cmd.OutputTo acOutputQuery, "Monthly Detailed Report", Excel97-Excel2003Workbook(*.xls)", "Screen.ActiveForm!Text1216 & " \ "& Monthly Detailed Report...... The...

Morning, I am trying to create a formula that will minus F51 by B59 if D59 =P, i have tried formula =SUMIF(D59,"P",F51-B59) but this creates an error. I am thinking SUMIF is not the correct formula I need to use as I am trying to subtract. Can any kind person please help me resolve this please...

I use Power Query to massage data from a number of sources. It works great. There are cases where to create the right analysis that I use pivot tables. When I create the pivot table, I select External sources and select the appropriate Query as input. Everything so far works great. The issue...

I am wondering if I can get suggestions from the experts here how best to proceed. I am trying to take my companies 10 sales goals and turn the monthly data into a dashboard so that my boss can quickly view progress. Each goal has a production number, goal, and deficit/surplus to goal. The goals...

I have this spreadsheet that I am trying to create for payroll reminders for weekly, fortnightly and monthly clients. With the Weekly pay clients I need to trigger every Tuesday to be highlighted. With the fortnightly clients I need to trigger every second Tuesday and for the monthly clients I...

I am building a cash flow model. Standard income and expenses. the model has months 1-60. I need the expenses to me put in by range. for example taxes will be in month 13 to 33 and insurance will be in months 19 - 44. I am looking for a formula that will look up the ranges and return data in the...

Do you know of a way to forecast a monthly service level if you have the monthly volume (all up), AHT and actual FTE that will be staffed?

Hi guys, I have such a difficult time explaining theissue but will try my best and attach file for an example. So in my example: each month a number of new customers come each month (Input),each monthly set of customers has an input on how many times they will return(Input). This will change...

I am trying to make some way to transfer specific entries to a monthly sheet, that is not depending on the date. I want to select the row then choose a month from a combo, txtDirectMonth and type a year into txtDirectYear then press a button. I then want the row to transfer to the relevant...

Hey guys, So I have a list of total monthly salary for each person. The trouble is each person is split among 16 jobs with various percentages. Is there a simple formula to sum all of the salary devoted to each job without building out monthly calculations for each project? My data is arranged...