1. B

    VBA code to create pivot table on quarterly basis

    Hi People, I have a data from A to X in sheet1 where there is weekending date in column "E" in format of mm/dd/yyyy. Can someone help me with VBA code to perform below steps. 1. I have sheet named Pivot which needs to be cleared and have new pivot tables with source data from sheet1 2. first...
  2. R

    quarterly calcs from month numbers

    I've been asked to calculate quarterly dollar spread based on start and end months. I need it in this format. removed bad image Q1 calc is easy, but gets complicated (for me) on the rest. Any help would be greatful. Thank you. <tbody> start month end month total cost q1 q2 q3 q4 3 7...
  3. W

    Next due date in FY 2019-20 based on frequency of payment & start date

    I want help with formula for calculating first payment date falling under period 01/04/2019 to 31/03/2020 based on frequency i.e. Annual, Monthly, half Yearly, Quarterly from any date. e.g. Start date- 05/08/2012 ( it can range back to year 1950) Frequency- Half yearly/Quarterly Result...
  4. D

    Help updating and comparing priclist

    Hello, I was hoping someone here could help me out. I have looked on the web, but do not seem to know what I should exactly be looking for. So here goes: I have a pricelist with part numbers that I receive an update to quarterly. sometimes price will be updated, and sometimes new products are...
  5. F

    How to calcuate YTD Sum with Quarterly/Half Inserts

    Hi there - I am working on a file where expenses are listed by month. However,within that range, there are quarterly and half sums. So the range looks like: J, F, M, Q1, A, M, J, Q2, H1, J,A, S, Q3, O, N, D, Q4, H2, FY Looking for a way to calculate year to date expenses, excluding the...
  6. C

    Quarterly Bonus Calculation with a cap - Help needed

    Have a problem getting the formula down. I've tried =MIN(January!C20*0.25*0.15) my salary field my % field =MIN(0.15,(January!E3+February!E3+March!E3)/3) The salaries vary. So let's say on a 75,000 dollar salary, the quarterly bonus can pay out no more than 15% or no more than 2,812.50. But...
  7. S

    Months to quarters

    A sales database processes reports that can both we monthly or quarterly. For the quarterly ones the data can be presented in the following format: "Jan-18,Feb-18,Mar-18" Is there a formula that could recognise such a string and product a result (in this example): "Q1-18" Thank you.
  8. J

    Calculating values by date range

    Hi all I have a spreadsheet where I have a sales forecast by both annual and quarterly breakdowns. Where I have a start date quoted, unless it is at the start of the quarter, I don't get an accurate figure in the Q1/2/3/4 columns. Example - Correct result (manually obtained) Part A - Agreed...
  9. B

    Drop-down list to appear if a condition is met

    hello, I have a drop-down list in cell B3 with 4 items (Monthly, Quarterly, Semi-annual, Annual). I would like to have a drop-down list appearing in cell C3 (with 2 items, Group1, Group2) only if the value of B3 is Quarterly. This means that if, for example, the value in B3 is Monthly, then...
  10. P

    Calculating And Comparing Values In Any Two Columns Selected

    Hi, I'm not sure if it's possible, but this is what I'm trying to achieve. I have a sheet with around 40 columns. Each column has a heading (name of a different company). Going down the first column are the following labels (Gas: Unit Price, Cost Monthly, Quarterly, Annually). This is repeated...
  11. M

    Viewing supporting quarterly data in a pop-up when yearly totals are charted

    Good morning. This is my first post. I am charting 3 years of comparison data with just the yearly totals displayed on the charts. Is there a method for displaying the figures for each year's 4 quarters of supporting data when the user rests the cursor on the annual figure on the chart? I am...
  12. M

    How can I change quarterly data into yearly?

    Hi guys, I researched some data for my project, and the problem is that it's shown as quarterly, so instead of having 2005, 2006, 2007 etc. I have Jan-March 2005, April - June 2005, July - Sep 2005 etc. What's the formula to change it? I tried everything, I'm really bad with excel anyway so I'm...
  13. B

    Formula Help: Financial Liquidity Calendar

    Hi, I work for a college endowment and am creating a spreadsheet/calendar that has all of liquidity terms for our different funds. The idea is to use the =TODAY function to have the spreadsheet be responsive and continuously be current. I'd love your help in developing a formula that will...
  14. G

    Value used in the formula is of the wrong data set.

    I have the following formula: =IF(AP32*AQ32*AR32*AS32>0,"Y","N") I am creating a spreadsheet that gives results on a monthly basis and on a Quarterly basis. Under the quarterly basis I am getting the valued used error only on the columns that are blank. Not sure why this is happening only...
  15. C

    index/match with multiple results help needed!

    Hello! I am attempting to create a formula using index/match that will return results on a list where there can be up to 6 matches. I have been able to do this however, if I have less than 6 (my max) match results my formula begins to give me results that are not a match. What I want is if my...
  16. M

    Quarterly Graphing

    I want to make an Excel graph of quarterly data where the X axis has four tick marks for each year, and the major tick mark is labelled with the year, but no labels on the other quarterly tick marks.
  17. T

    Performance report

    I'm tying to rebuild our sales rep quarterly/year-end performance report to account for quarterly metrics weighting changes. Generally the performance metrics (attainment to quota and product volumes) have the same weightings each quarter so calculating the year-end ranks are easy, (YTD...
  18. J

    Quarter Years based on Start Date

    Hello everyone... I have a situation that is really puzzling with me, so I thought I would ask on the forum. In column A, I have a list of "start dates" (ex: 1/1/2017, 5/1/2017, etc) In row 1, I have consecutive date headers (i.e. 1/1/2017, 2/1/2017, 3/1/2017, 4/1/2017 .... )...
  19. N

    Change quarters with date criteria

    Hi good people, I am creating a monthly financial model from Jan-17 to Dec-19. I need help with the rent calculation. In my input sheet I have two inputs for rent 1) Start Date 2) Amount (annual figure) which is paid quarterly. What ever my start date is I want my rent to start on that date and...
  20. L

    Calculate every 3rd month

    So I'm trying to calculate every 3rd month, (quarterly month). For example today is Aug, I want to create a formula where I input any date in Aug (8/1/2016) and it gives me 11/1/2016, also I want it to continue to reciprocate ever 3rd month automatically, like come 11/1/2016 it will then change...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back