running analysis

  1. A

    How to find usual credit card amounts by each day of the month?

    [having trouble uploading sample data] The credit card period runs from the 6th of month 1 and ends on the 5th of month 2. Then, the payment is due on the 2nd of Month 3. Then, the 6th of month 2 runs to the 5th of month 3. etc. I am trying to find the typical credit card amount for each day of...
  2. D

    Spreading Values while dates....

    I have been trying to figure out a formula to show how many days a project would take if a start date was given and hours of project assuming a person worked 8 hrs per day. See example below. I used the formula MIN(D$3-SUM($F$3:G3),8), which will "spread" the "8" until it reaches "0", but when...
  3. K

    Running total with two pertinent Date columns

    Hello all, I believe I need DAX measure and I'm not finding what I need on the google machine. It's also possible I found what I need but did not comprehend it. First of all, I'm using Excel (PQ & PPivot). I have two tables. Here's the first: Note each employee can have multiple positions...
  4. D

    Unsure how to approach my problem, need help with making a league excel sheet

    Hey Guys, Thank you for reading my question(plea for help), I really appreciate your help (I'm on my knees, begging) I am making a bowling league excel sheet, I will have 10 - 15 teams. Each team will start of with a rating. - There may be no games on a particular day, or more than 1...
    • DrExcel2035
    • Thread
    • data analysis data array ranking rating system running analysis
    • Replies: 8
    • Forum: Excel Questions
  5. M

    In need of Macro/Formula to automate list of tabs within running list of first tab and a macro/formula to populate data within dataset of each tab int

    https://www.box.com/s/8c70deb964524d2d8111 File Name: TestMrExcel Please see the attached document. My desire is to pull a value from a dataset based on certain parameters. I would like to complete the following within the document (example) but on a larger scale. I need a macro/formula...

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