5/30/2019

  1. M

    Sorting, grabbing, and averaging a lot of data into a few cells by date...

    I need some assistance trying to grab some data from one column and move it to another. Let’s say I have column P with dates of the month, the data in this column will change at times. Say 10 samples per day. Column “Q” has a number for each sample. I would like to scan “P” and report the...
  2. R

    Aged Dates Categorize

    I need help with a formula or formulas to count and categorize aged dates based on the aging range below. There is a fixed date at the top of the report that it will be compared to that is not a today formula. There is a lot of information above and below where this information will be pulled...
  3. M

    Using Index Match with SumProduct

    Hello- I have two pivot tables from different weeks that consist of date, a sales deal name and the value of the deal. I need to see the changes in values on each deal that have occurred from week to week. In the table below, I want to create a formula in a column outside of Pivot Table #1...

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