complex data

  1. anna82marie

    Complex formula problem

    Good morning! I may have over-stretched myself with a training matrix that I have created. I have figured out the formulas to return the number of red, amber, green based on the validity period for ALL staff, but can't for the life of me amend the formula to give me the results for a specific...
  2. K

    Creating a Pivot Table from a complex Excel sheet, how do I get this to work?

    Hello! I am attempting to create a Pivot Table from a complex Excel sheet. Below is an example of 1 item I am tracking.... this is 1 of 70, and they usually have 20 or so "Social Insertions". The goal of the Pivot Table/Chart is to have an easy to digest overview of the month and of the...

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