excel & pivot

  1. F

    Pivot Tables Counts Blank Cells when calculating Distinct Values

    Hello All, I am trying to create a pivot table which should show the distinct values for Data elements in Column 1, these Data Elements are connected with Objects 1,2,3 with the names given in the table below. Data E Object 1 Object 2 Object 3 Account ID ACC_ID DQ_R1 DQ_C1 Account Code...
  2. M

    Pivot table is unable to count different date ranges

    Hi all, I've tried to search for the solution but was unable to find it, hence I hope you folks can help. I have created a pivot table where I have two columns - Date Received and it contains dates when the item was received and then I have a column Date Completed and it contains the dates...

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