Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 615
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, 11 views)
Attached Files
File Type: xlsx intervals.xlsx (11.6 KB, 9 views)
Reply With Quote
 

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 02:20 PM.


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