bins

  1. C

    Start histogram Bins at 0

    I am trying to do a histogram in excel with the bins starting at 0 and each Bin being 0.2 in width. However when i set the bin width at 0.2 it starts the first bin at 0.11 because that is the lowest number in the dataset. how do i get the bin to start at 0 so that that the bins are...
  2. D

    SUMIFS with INDEX MATCH at a loss

    I have a worksheet called "Summary" that should show the total sales by month by category. On a separate worksheet, called "2019", I have a list of sales. I am trying to update the "Summary" worksheet to show the sum of all of sales for each category for each month. The formula I have at this...
  3. Amosbroker

    Frequency Formula - Meeting multiple criteria

    Ok - usually I can search these message boards or find a YouTube video, it's just not happening for me today. I am looking to count unique ID's in one column that meet criteria in three other columns. Column G = "" (blank) Column O = Completed Column L - Coaching Column F contains my ID's I...
  4. J

    Excel historgram question

    Hi All, I'm making an Excel histogram with 100 bins. I don't want 100 labels for the bin values, however. How can I limit the number of labels on the bins (i.e. have 100 bins but only 5 value labels)? Thank you!
  5. X

    Populate Date Based On Non-Modal Count?

    Dear All, I do have a sample data set across A1:E4. The data represents the NO Of BINs in which the SKU is kept at the DC. I would like to figure out the dates on which the no of BINs is more than the Modal no of BINs across a given period. The formulae put in F2=COUNTIF(B2:E2,"<>"&MODE(B2:E2))...
  6. M

    Histogram Bins

    I have a set of data that I would like to create bins. For example, 45, 23, and 10 will fall in the 0-49 bin. I created the histogram but am struggling in changing the ranges to display as the bins as the ranges below.:confused: Data: 45 23 897 456 123 10 Bins 0 - 49 50 - 99 100 - 175 176 -...
  7. T

    Pulling Values within a Range

    Hi guys, I was hopeful someone could help me with a formula that will look up a number (E3) and return an associated profile that is within a certain range (range of 100 bins).... For example I know that on Week 2 I will process 1200 bins (F3), and I know that the Heavy (1) profile should be...
  8. V

    How to group employee experience numbers 11.03, 0.11, 10.00 in pivot table and then it should get the count

    Hi i have a sheet with column Total Experience and all these numbers are as follows. 11.03, 0.1,0.11. So my boss wants to know the count of the members as 0-2 years experience how many members, 2-5 years experience how many members, 5-8 years experience how many members,8-10 years experience how...
  9. S

    Dynamic bins for mulitple data sets

    Hi Everyone, I'm not that technical and I'm hoping someone wouldn't mind helping. I have multiple data sets which vary both in range (lower and upper bounds?). Each data set will also change for each new scenario, for example on any given date Set 1 might have a range of -4 to +4 and the next...
  10. W

    Calculating Schedule Time in Bins

    I have a large amount of schedule data that I am trying to bucket into half hour increments. I am looking for any assistance on the best way to do this. Here are the 4 important columns: 1) Segment Start Time (ex. 05/02/2015 12:33:00) 2) Segment End Time (ex. 05/02/2015 13:33:00) 3) Segment...
  11. S

    Applying Filters to 'Groups of Rows'

    Hi. Situation: I am analyzing data of a courier company. The data is organised into rows with each row representing a delivery from pickup to destination. I now wish to understand performance of the couriers over different distances (delivery lengths). The total distance of each delivery...

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