Results 1 to 8 of 8

Excel illiterate: frequency for intervals

Threaded View

  1. #1
    Registered User
    Join Date
    03-02-2014
    Location
    London
    MS-Off Ver
    excel2013
    Posts
    3

    Excel illiterate: frequency for intervals

    I am illiterate in excel, sorry if my question seems stupid:

    I am dealing with intervals: A1 = max value of set interval; B1 = min value of set interval

    A B
    1 7051 6770
    2 6654 6462
    3 6459 6253
    4 6684 6469
    5 6439 6253
    6 5720 5513
    7 5838 5623

    I am looking for a formula to calculate the frequency of intervals that fall within a 500-mark range; In effect, the same interval would count more than once:

    The frequency in this case would be (if my calculations are right)
    7500-7000: 1

    7000-6500: 3

    6500-6000: 4

    6000-5500: 2



    Thank you in advance for any suggestion!

    xi
    Last edited by xim78; 03-02-2014 at 06:04 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy With Intervals Paste With No Intervals.
    By gorinw10 in forum Excel General
    Replies: 12
    Last Post: 07-20-2013, 12:23 PM
  2. Count Frequency of Intervals
    By banjogabano in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-11-2013, 04:52 AM
  3. Converting Data in Irregular Time Intervals into Regular Time Intervals
    By AlexJT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2011, 02:42 AM
  4. Need to Transpose Irregular Time Intervals into Regular Time Intervals
    By AlexJT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2011, 08:30 PM
  5. excel macro illiterate - need to copy information out of sheets
    By darknature in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-03-2011, 11:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1