Results 1 to 3 of 3

Thread: Extracting Data

  1. #1

    Extracting Data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    By highlighting a large group of numbers from 1 to 54 in 6 columns, I wish to determine how many or the frequency with which any of those numbers occur.
    In the example below and excluding the column number, 5 occurs twice, 26 occurs 3 times. I need a formula that would yield the frequency of each number from 1 to 54, in the block of 1 to 6 columns.


    1 2 3 4 5 6
    25 26 31 40 46 50
    1 8 14 22 26 34
    4 9 11 28 31 33
    27 30 37 39 45 53
    5 8 16 32 34 37
    4 22 26 37 50 54
    5 12 21 22 24 30

    Thanks in advance

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Plz see the file. is it solve your requirement ?
    Attached Files Attached Files

  3. #3
    Quote Originally Posted by sambit View Post
    Plz see the file. is it solve your requirement ?
    Worked nicely Thank you. Appreciate yr help.

Tags for this Thread

Posting Permissions

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