|
|
|
|
#1
07-09-2012, 09:05 AM
|
|||
|
|||
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 
|
|
#2
07-09-2012, 11:39 PM
|
||||
|
||||
Perhaps the FREQUENCY function might help?
__________________
Using O365 v2503 - 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
07-10-2012, 02:50 PM
|
|||
|
|||
|
Quote:
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
|
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode