Results 1 to 1 of 1

calculating frequency across groups

Threaded View

pani_hcu calculating frequency across... 08-24-2012, 09:56 AM
  1. #1
    Forum Contributor
    Join Date
    10-11-2008
    Location
    Chennai,India
    MS-Off Ver
    2007,2003
    Posts
    123

    calculating frequency across groups

    Dear All,

    I want to calculate the frequency of each CELL value in B Column ( 1<=CELL VALUE<= 26) ACROSS VALUES OF A COLUMN which varies from 1 to 23.

    A B

    1 26
    1 26
    1 25

    2 24
    2 24

    23 6

    I want to calculate my code which is in B column how many times coming in A column for the No 1 t0 23. Likewise i want to calculate for all the values in B which varies from 1 to 26.

    Please help me with a formula to do this

    I will be grateful for your help. Please find the attached file for your reference.

    With kind regards,
    Upananda
    Attached Files Attached Files
    Upananda

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