grouping and counting

  1. S

    Gouping the value with from and to date.

    Dear Experts, Really first of all i would like to appreciate all the experts here, whenever the question is been raised the response will be immediate or max to max within a day solution will be given. Here i have come up with an query too.. <colgroup><col><col...
  2. T

    Dividing rows into groups based on two parameters

    Dear all, I have the following problem: I need to divide the rows below into groups, based on two criteria. e.g. The sum of Balls <= 10.000 & the sum of Bucket <= 5 the order of the rows cannot change. Is there an (easy) way to let excel determine these groups? the result in the row...
  3. M

    graphing fleet mileage groups

    I have a list of trucks, 600, and I have the current total miles for all trucks how can I take that list of data and cart it to look at the distribution of trucks within various segments such as 0-50000, and 50001 - 100000, 100001 - 150000 and so on?
  4. F

    Categorize from list base on list

    Hi everyone, Sorry for the title, a bit confusion. Not sure if I cant articulate this well enough. I would like to categorize a set of information based on a list. Let me show you what i mean. This is the information I have. City HK Hong Kong New York Jersey New Jersey Manila Makati If I...
  5. M

    Confusion on Grouping and Counting

    Hi All, Hoping for some help on this one. I am trying to determine if I can convert certain data within Excel 2003 on XP to give me the total number of policies per representative (not individual units) on a spreadsheet. (Some policies have multiple clients on them but, I want just to have a...

Some videos you may like

This Week's Hot Topics

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
Top