Results 1 to 5 of 5

complicated count

Threaded View

  1. #1
    Registered User
    Join Date
    11-08-2006
    Posts
    24

    complicated count

    Ok, I have a large range of data of basically random numbers. I want to count the occurances of the different numbers when a certain number pops up. Let me give an example:

    I have these values (see example2.jpg) and I want this output.

    So, for the rows that contain a "1" then it counts, if any, how many of the other numbers are in that row. In this case, there are 2 "2's", 4 "3's", 2 "4's", 1 "5", and 1 "6".

    Thanks for ya'lls help!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

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