Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2012, 09:05 AM
Jamal NUMAN Jamal NUMAN is offline Categorising values in intervals Windows 7 64bit Categorising values in intervals Office 2010 64bit
Expert
Categorising values in intervals
 
Join Date: Nov 2010
Posts: 519
Jamal NUMAN is on a distinguished road
Question 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
Attached Images
File Type: jpg Clip_259.jpg (97.9 KB, 9 views)
Attached Files
File Type: xlsx intervals.xlsx (11.6 KB, 7 views)
Reply With Quote
  #2  
Old 07-09-2012, 11:39 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Categorising values in intervals Windows 7 64bit Categorising values in intervals Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 07-10-2012, 02:50 PM
Jamal NUMAN Jamal NUMAN is offline Categorising values in intervals Windows 7 64bit Categorising values in intervals Office 2010 64bit
Expert
Categorising values in intervals
 
Join Date: Nov 2010
Posts: 519
Jamal NUMAN is on a distinguished road
Question

Quote:
Originally Posted by Pecoflyer View Post
Perhaps the FREQUENCY function might help?
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
Attached Images
File Type: jpg Clip_262.jpg (64.0 KB, 8 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
swap values s7y Excel Programming 0 05-15-2012 01:32 PM
Categorising values in intervals 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
Categorising values in intervals How to get the inverse of the values in the same table? Jamal NUMAN Excel 4 04-16-2011 06:24 AM
Categorising values in intervals Using Conditions to Add Values EclipticalD Excel 1 07-08-2010 09:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft