+ Reply to Thread
Results 1 to 3 of 3

comparing 2 columns and count results

  1. #1
    Registered User
    Join Date
    10-15-2008
    Location
    Plano
    Posts
    1

    Thumbs down comparing 2 columns and count results

    i have a serious problem. I have been trying to do a conditional countif.
    I have 2 columns of data.

    A B
    1 0
    1 2
    1 2
    1 2
    2 4
    2 1
    2 3
    2 3
    2 1
    2 3
    3 0
    I need to count how many times when A = 1, B=0
    I need to count how many times when A = 1, B=1
    I need to count how many times when A = 1, B=2
    I need to count how many times when A = 1, B=3
    I need to count how many times when A = 1, B=4
    I need to count how many times when A = 2, B=0
    I need to count how many times when A = 2, B=1
    I need to count how many times when A = 2, B=2
    I need to count how many times when A = 2, B=3
    I need to count how many times when A = 2, B=4
    and so on for 45001 rows
    the range on A is 1-12
    The range on B is 0-26

    Can someone please help me?

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Try:

    Please Login or Register  to view this content.
    copied down
    Last edited by NBVC; 10-15-2008 at 11:50 PM.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561
    Use a pivot table
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort and Count Unique Data in 4 Columns
    By miakayuuki in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2008, 11:22 AM
  2. [SOLVED] Comparing two columns of data
    By elevdown in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2007, 10:13 AM
  3. Count Number of Columns
    By mrdata in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-03-2007, 04:44 PM
  4. Comparing Data Between Two Columns
    By PennyLane_79 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-06-2007, 11:24 AM
  5. Count duplicate combinations in 2 columns
    By s80NL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2007, 10:10 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