variance formula

  1. I

    Variation and ranking

    I couldn't find a place to post this question so I was advised to create a new thread. I'm looking for a formula to calculate the variation from a standard time set e.g. 20:30 (mm:ss). I have around 23 different times in a column and I want to put a formula next to it to find the variation and...
  2. M

    finding the most called numbers in a table

    Hi Everyone, I have been trying to figure out how to find the most called numbers in a group of numbers in excel. I want to find out the most called numbers in this example below, how many variations? I have office 365 Any help would be greatly appreciated. Mike <colgroup><col><col><col...
  3. B

    Calculating Variance Between Two Tables in a Data Model

    Hello, I have two tables in Excel 2013: Actual & Forecast. Both tables have the following similar columns: Period, Account, Amount. I've included them in a Pivot Table Data Model and would like to calculate a variance between Actual[Amount] and Forecast[Amount]. I'm unable to utilize the...
    • bigburge10
    • Thread
    • excel 2013 pivot table tables variance formula
    • Replies: 6
    • Forum: Power Tools
  4. E

    Budget/Actual Variance Fomula please

    I am working on a Budget Variance Report and need some help with the formulas. I believe I have the total % and the regular % variance mixed up. I pasted the formula I was using, but I don't know if it would go in the % of total, or the % Variance. Also, I am struggling with what formula I would...

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
Back
Top