Results 1 to 2 of 2

Count occurrences based on criteria in another column

Threaded View

  1. #1
    Registered User
    Join Date
    10-06-2013
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    1

    Count occurrences based on criteria in another column

    Hi all,

    Sorry if this type of question has been asked a lot. I've tried to do search for it but haven't been able to find a solution yet.

    I'll try to explain this based on an example. Consider the following text:


    12.1 1
    2.3 4
    0.9 2
    1.1 3
    7.4 1
    There are essentially 16 possible values in Column B. For each value, I need to know how many times there's a corresponding value in Column A within a certain range, for example between 0 and 5, between 5 and 10, etc. In the end, I'll need a matrix with the Column B values running down one side, and the ranges across the top, and the number of occurrences filling the matrix.

    <5 5<x<10 ....
    1 0 1
    2 1 ... etc.
    3 ....
    4
    5


    Hopefully this is clear. Please help! Thanks.
    Last edited by nwapple; 10-06-2013 at 08:31 PM. Reason: formatting

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count occurrences of text with various criteria
    By ludgirardi in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 12-18-2012, 07:50 PM
  2. Replies: 5
    Last Post: 09-18-2011, 10:44 PM
  3. Count of occurrences until a criteria met
    By dazlan in forum Excel General
    Replies: 0
    Last Post: 02-12-2011, 09:27 AM
  4. Count occurrences based on criteria
    By Justinmih in forum Excel General
    Replies: 2
    Last Post: 01-05-2011, 09:07 AM
  5. trying to COUNT occurrences when certain criteria is met
    By Allan from Melbourne in forum Excel General
    Replies: 4
    Last Post: 08-02-2006, 06:05 AM

Tags for this Thread

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