+ Reply to Thread
Results 1 to 14 of 14

Excel 2008 : i need formula for cumulative frequency for two coexisting values in two different columns

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    london,England
    MS-Off Ver
    Excel 2010
    Posts
    5

    i need formula for cumulative frequency for two coexisting values in two different columns

    i want help with ms excell 2010

    i have two columns and i want formula that will add up the frequency of value in both columns whenever they are same, e.g


    a b 1
    c d 1
    a b 2
    b a 1
    a b 3

    i want formula that will do this for me every time same value occurs in the two colums
    Last edited by mgbajwa; 06-21-2012 at 04:18 AM.

  2. #2
    Registered User
    Join Date
    06-21-2012
    Location
    london,England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: helppppp


  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: helppppp

    Whilst you have been waiting for help you should read the Forum Rules, espcially about threadtitles
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: helppppp

    As Roy said:

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.


  5. #5
    Registered User
    Join Date
    06-21-2012
    Location
    london,England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: helppppp

    oh i am so sorry. Where is the edit button??

  6. #6
    Registered User
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    34

    Re: helppppp

    uplod your workbook buddy i cudnt get your prob
    SANDEEP
    << press the star * if u like

  7. #7
    Registered User
    Join Date
    06-21-2012
    Location
    london,England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: helppppp

    Book2.xlsx


    here you are,

  8. #8
    Registered User
    Join Date
    06-21-2012
    Location
    london,England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: helppppp

    please admin edit my title, i can't find how to do it

  9. #9
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: helppppp

    Go to first post -> Click Edit -> Go advanced and change title

  10. #10
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: *** Frequency functions excell

    Please describe your problem, not your anticipated solution

  11. #11
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: i need formula for cumulative frequency for two coexisting values in two different col

    Here, try this (First is 1 as it should be always 1):
    Attached Files Attached Files

  12. #12
    Registered User
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    34

    Re: i need formula for cumulative frequency for two coexisting values in two different col

    Book2.xlsx


    here it is done ... cheers.. a simple cross check matrix ( u can hide it )

  13. #13
    Registered User
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    34

    Re: i need formula for cumulative frequency for two coexisting values in two different col

    make this thread [SOLVED]... hv a gr8 day

  14. #14
    Registered User
    Join Date
    02-22-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Excel 2008 : i need formula for cumulative frequency for two coexisting values in two

    Hi i have a column with 6000 vlaues that alos include duplicates. I need to calculate cumulative frequency of this data. Could anyone help me. thanks in advance

+ Reply to Thread

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