#1
|
|||
|
|||
Categorising values in intervals
Categorising values in intervals
Is there a way in excel to categorise the values in interval and then show the count included in each interval. i.e, is possible in excel to derive intervals from raw values and to assign the frequency of each interval. For example, in the attached screenshot, it is shown raw values from which intervals and their frequencies are derived. Is there a way to do that automatically in excel? Thank you for the help Best Jamal
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#2
|
||||
|
||||
Perhaps the FREQUENCY function might help?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Many thanks for the answer.
The issue here is how to get the interval written automatically along with their counts (screenshot is attached)? What I’m looking for is to derive the interval themselves (based on given break values) and their count. What other option might be there? Best Jamal
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
swap values | s7y | Excel Programming | 0 | 05-15-2012 01:32 PM |
Processing Time Intervals | pkrishna | Excel | 5 | 09-30-2011 06:24 AM |
Reading Values from another sheet | Raabi | Excel | 2 | 05-20-2011 02:14 AM |
How to get the inverse of the values in the same table? | Jamal NUMAN | Excel | 4 | 04-16-2011 06:24 AM |
Using Conditions to Add Values | EclipticalD | Excel | 1 | 07-08-2010 09:50 PM |