+ Reply to Thread
Results 1 to 5 of 5

Trying to sum frequency of duplicated words

  1. #1
    Registered User
    Join Date
    07-16-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    2

    Trying to sum frequency of duplicated words

    Hi guys, I am rather noob in excel so pardon me if my request seems a bit easy.

    So for example, i have the data set below, how do i sum the frequencies of the duplicated words? I cant do it manually because my data sets are quite large

    so ie end result should be like
    abdul 2
    able 2
    ..
    accounts 5
    ..

    Words Freq
    abdul 1
    abdul 1
    able 1
    able 1
    about 1
    about 1
    abu 1
    abu 2
    accounts 2
    accounts 3
    achieved 1
    achieved 1
    achievement 5
    achievement 1
    acquiring 1
    acquiring 1
    activities 3
    activities 1
    activities 3
    activities 1
    address 10
    address 3
    address 1
    address 1
    address 2
    address 1
    administration 3
    administration 1
    administration 2
    advertising 1
    advertising 1
    advising 1
    advising 2
    age 2
    age 1
    age 1
    agri 1
    agri 1
    agricultural 1
    agricultural 19
    agricultural 5
    agricultural 3
    agricultural 15
    agriculture 2
    agriculture 1
    agriculture 1
    agriculture 5
    agriculture 5
    agriculture 2
    agriculture 22
    agronomic 1
    agronomic 2
    agronomist 1
    agronomist 1
    agronomy 1
    agronomy 7
    all 2
    all 5
    all 1
    all 5
    along 1
    along 1
    also 1
    also 1
    analysis 3
    analysis 1
    analysis 1
    application 2
    application 8
    application 2
    application 2
    applying 1
    applying 1
    aqua 2
    aqua 1
    area 4
    area 9
    area 3
    asia 4
    asia 1
    asian 2
    asian 20
    assigned 2
    assigned 1
    assist 1
    assist 1
    associations 3
    associations 1
    attainment 1
    attainment 1
    attractive 1
    attractive 1
    availability 1
    availability 1
    available 1
    available 2
    avenue 1
    avenue 2
    awareness 1
    awareness 1
    bachelor 2
    bachelor 1
    bachelor 2
    bachelor 2
    background 1
    background 1
    base 1
    base 1
    base 1
    basic 1
    basic 1
    basic 1
    being 1
    being 2
    below 1
    below 1
    benefits 1
    benefits 1
    best 1
    best 1
    between 1
    between 1
    bhd 6
    bhd 2
    biological 1
    biological 3
    birth 2
    birth 1
    birth 1
    birth 1
    birth 1
    board 2
    board 2
    board 1
    box 3
    box 4
    box 1
    box 1
    budgets 1
    budgets 2
    build 1
    build 1
    building 1
    building 2
    building 2
    business 21
    business 1
    business 2
    business 3
    business 1
    business 1
    buying 1
    buying 1
    cabbage 1
    cabbage 1
    camps 3
    camps 1
    can 2
    can 1
    career 1
    career 1
    cauliflower 1
    cauliflower 1
    center 1
    center 4
    center 6
    central 1
    central 2
    centre 1
    centre 1
    centre 1
    centre 1
    centre 4
    chain 1
    chain 1
    challenges 1
    challenges 1
    challenges 1
    charge 6
    charge 1
    chemical 1
    chemical 1
    chief 1
    chief 2
    chief 1
    chinese 1
    chinese 16
    choice 1
    choice 1
    city 3
    city 2
    city 2
    city 1
    civil 1
    civil 1
    class 4
    class 1
    clients 1
    clients 1
    college 2
    college 1
    com 1
    com 1
    com 2
    com 3
    com 1
    com 1
    com 1
    com 3
    commercial 1
    commercial 1
    commercial 1
    commodities 1
    commodities 2
    community 1
    community 1
    companies 1
    companies 2
    company 3
    company 3
    company 4
    company 9
    company 3
    complaints 1
    complaints 1
    computer 1
    computer 1
    computer 1
    computer 1
    concept 1
    concept 1
    conducting 1
    conducting 1
    conducting 1
    conference 1
    conference 5
    consideration 1
    consideration 1
    consideration 1
    contact 2
    contact 1
    contact 1
    contract 2
    contract 2
    contribute 1
    contribute 1
    control 1
    control 1
    control 3
    control 2
    cooperative 2
    cooperative 1
    coordinate 2
    coordinate 1
    coordinating 3
    coordinating 1
    coordinating 1
    coordination 1
    coordination 1
    corn 2
    corn 1
    cost 4
    cost 1
    course 2
    course 1
    course 2
    create 2
    create 7
    creative 2
    creative 1
    credit 1
    credit 1
    cristo 3
    cristo 2
    crop 1
    crop 3
    crop 2
    crop 1
    crop 15
    crops 1
    crops 1
    crops 5
    crops 3
    crops 5
    cultivating 1
    cultivating 3
    cultivation 3
    cultivation 9
    culture 4
    culture 1
    current 1
    current 1
    currently 1
    currently 1
    curriculum 1
    curriculum 1
    curriculum 1
    customer 4
    customer 5
    customer 1
    customer 2
    customers 2
    customers 2
    daily 1
    daily 1
    dairy 1
    dairy 6
    dairy 1
    dairy 1
    data 1
    data 1
    data 2
    date 1
    date 1
    date 2
    date 3
    date 1
    date 1
    day 2
    day 2
    dealers 1
    dealers 1
    dec 1
    dec 1
    dec 1
    dec 1
    december 1
    december 1
    december 1
    degree 5
    degree 2
    department 3
    department 3
    department 4
    deputy 3
    deputy 1
    design 1
    design 1
    designing 2
    designing 1
    designing 6
    designing 1
    details 1
    details 1
    details 1
    details 1
    develop 1
    develop 1
    develop 1
    develop 1
    developing 5
    developing 16
    development 12
    development 4
    development 1
    development 4
    development 10
    development 1
    development 2
    development 23
    dhabi 1
    dhabi 2
    diploma 1
    diploma 1
    diploma 1
    direct 1
    direct 2
    director 1
    director 2
    director 4
    director 4
    disease 1
    disease 1
    distribution 2
    distribution 1
    distributors 1
    distributors 1
    district 2
    district 1
    district 1
    division 4
    division 2
    division 1
    division 4
    drive 1
    drive 1
    driving 1
    driving 1
    duties 3
    duties 6
    dynamics 1
    dynamics 1
    east 1
    east 3
    east 2
    economic 3
    economic 3
    edgardo 2
    edgardo 1
    education 1
    education 1
    education 1
    education 3
    education 1
    education 1
    educational 1
    educational 1
    educational 1
    effective 1
    effective 1
    effective 1
    effective 1
    effectively 1
    effectively 2
    efficiency 1
    efficiency 1
    egypt 1
    egypt 2
    email 1
    email 1
    email 3
    email 1
    email 1
    email 4
    e-mail 1
    e-mail 1
    e-mail 1
    engineering 1
    engineering 2
    english 2
    english 1
    english 1
    english 1
    english 1
    ensuring 1
    ensuring 1
    environment 4
    environment 1
    environmental 1
    environmental 1
    equipment 1
    equipment 1
    establishing 2
    establishing 5
    establishment 1
    establishment 2
    estate 1
    estate 32
    etc 2
    etc 1
    etc 1
    excel 1
    excel 1
    excellent 1
    excellent 1
    executive 2
    executive 1
    existing 1
    existing 1
    experience 1
    experience 2
    experience 1
    experience 4
    experience 1
    experience 1
    experience 1
    experiences 2
    experiences 1
    expert 2
    expert 1
    export 1
    export 1
    export 3
    extension 7
    extension 2
    extension 1
    facilitating 1
    facilitating 4
    facilitating 1
    facilities 1
    facilities 1
    factory 1
    factory 1
    faithfully 1
    faithfully 1
    farm 4
    farm 1
    farm 1
    farm 12
    farm 2
    farm 2
    farm 5
    farmer 1
    farmer 1
    farmer 2
    farmers 14
    farmers 6
    farmers 1
    farmers 2
    farming 1
    farming 3
    farming 2
    farms 2
    farms 2
    fertility 6
    fertility 1
    fertilization 1
    fertilization 1
    fertilization 5
    fertilizer 1
    fertilizer 5
    fertilizers 1
    fertilizers 3
    field 2
    field 2
    field 2
    field 3
    fields 1
    fields 5
    first 2
    first 1
    first 1
    first 2
    focus 1
    focus 1
    focus 1
    food 1
    food 8
    food 2
    forecasting 1
    forecasting 1
    four 1
    four 1
    fresh 1
    fresh 5
    fruit 1
    fruit 2
    fruit 1
    full 1
    full 1
    full 1
    function 1
    function 6
    functional 1
    functional 1
    funded 2
    funded 1
    funding 1
    funding 1
    gather 1
    gather 1
    general 1
    general 3
    get 1
    get 2
    ghana 6
    ghana 3
    global 3
    global 1
    global 3
    gmail 1
    gmail 1
    goals 1
    goals 1
    good 1
    good 1
    good 1
    good 3
    good 1
    grade 1
    grade 1
    green 3
    green 1

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Trying to sum frequency of duplicated words

    Use pivot tables..
    www.cpearson.com/excel/pivots.htm‎

    Alternatively, for individual results use SUMIF
    hence,
    =SUMIF(A:A,"abdul",B:B)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Trying to sum frequency of duplicated words

    Assume
    col A = abdul
    col B = 2
    then at your col C =SUMIF($A$1:$A$100,"="&A1,$B$1:$B$100), drag down.
    After this, do a pivot table, to get each sum total.


    or you get each single data from col A 1st, example put at sheet2,
    abdul
    able
    about
    abu
    accounts

    then col B =SUMIF(Sheet1!$A$1:$A$100,"="&A1,Sheet1!$B$1:$B$100), drag down.
    You will have the answer.
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Trying to sum frequency of duplicated words

    Welcome to the forum

    Next time, please dont copy so much info into your thread. If you feel you need to show that much detail, put it into a sample file and upload it
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    07-16-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Trying to sum frequency of duplicated words

    Hi thank you all for your prompt replies!

    My problem is solved!Thank you so so much!!

    Regards,
    Jack

+ 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. How to find duplicated words
    By Refused07 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-14-2012, 01:19 PM
  2. Count frequency of words and make a table
    By arnold456 in forum Excel General
    Replies: 0
    Last Post: 11-28-2011, 07:08 AM
  3. ordering words by frequency
    By mogwai1968 in forum Excel General
    Replies: 3
    Last Post: 08-14-2011, 08:59 AM
  4. Words are duplicated in print-outs
    By agentred in forum Word Formatting & General
    Replies: 2
    Last Post: 07-14-2010, 10:43 PM
  5. frequency of occurance of all words in 2-D array
    By Richard in forum Excel General
    Replies: 4
    Last Post: 03-21-2006, 11:15 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