count occurances

  1. M

    Running unique count of occurrence on table based on date

    Hello, I have a report that is extracted daily Mon-Fri. I want to show the unique ticket number (because sometimes is duplicated) that is overdue on the day I extract the report and how many day(s) that ticket has been in the inbox and do that for the subsequent days. Examples: 1) Overdue...
  2. W

    Count items return which occurs most

    Using the following data (this list could be several thousand lines long): Apple Orange Strawberry Orange Apple Apple Tomato I would like to count and return the item that occurs the most (Apple) then the one that returns 2nd most (Orange). If item only occurs once then it can be ignored...

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