1. Log in now to remove adverts - no adverts at all to registered members!

O/T Excel Help

Discussion in 'Hull City' started by Davies Headband, Mar 31, 2013.

  1. Davies Headband

    Davies Headband Well-Known Member

    Joined:
    Jan 27, 2011
    Messages:
    2,474
    Likes Received:
    161
    I'm doing some work on Excel and need to count the number of times a certain word occurs in a selection of cells. I've tried Googling it and followed a couple of guides but I can't work out which formula it is I need.

    Can anyone shed any light on it please?

    Ta!
     
    #1
    Davies Headband, Mar 31, 2013
  2. onceatiger

    onceatiger Active Member

    Joined:
    Feb 5, 2011
    Messages:
    697
    Likes Received:
    59
    Presumably you've tried 'Find and select'
     
    #2
    onceatiger, Mar 31, 2013
  3. mauled1904

    mauled1904 Well-Known Member

    Joined:
    Jan 25, 2011
    Messages:
    1,389
    Likes Received:
    702
    put it in a pivot table
     
    #3
    mauled1904, Mar 31, 2013
  4. Davies Headband

    Davies Headband Well-Known Member

    Joined:
    Jan 27, 2011
    Messages:
    2,474
    Likes Received:
    161
    I want Excel to do the counting (if that makes sense) so that if one of the values changes I don't need to change the number I've come up with.
     
    #4
    Davies Headband, Mar 31, 2013
  5. rayhenderson retired

    rayhenderson retired Member

    Joined:
    Jan 31, 2011
    Messages:
    349
    Likes Received:
    20
    I didnt think words had a value in excel only nubers
     
    #5
    rayhenderson retired, Mar 31, 2013
  6. SW3 Chelsea Tiger

    SW3 Chelsea Tiger Well-Known Member

    Joined:
    Jan 27, 2011
    Messages:
    11,209
    Likes Received:
    17,418
    Use the exact function
     
    #6
    SW3 Chelsea Tiger, Mar 31, 2013

  7. Lardarsehesford City Hull

    Lardarsehesford City Hull Member

    Joined:
    Jan 24, 2011
    Messages:
    252
    Likes Received:
    1
    Put a filter on it then search by text
     
    #7
    Lardarsehesford City Hull, Mar 31, 2013
  8. The Omega Man

    The Omega Man Well-Known Member

    Joined:
    Feb 20, 2011
    Messages:
    8,278
    Likes Received:
    5,664
    =Countif(a1:a100,"Hull City")

    (Range of cells,"word")
     
    #8
    The Omega Man, Mar 31, 2013
  9. onceatiger

    onceatiger Active Member

    Joined:
    Feb 5, 2011
    Messages:
    697
    Likes Received:
    59
    The find and select results box will tell you how many its counted - if that's what you want?
     
    #9
    onceatiger, Mar 31, 2013
  10. Davies Headband

    Davies Headband Well-Known Member

    Joined:
    Jan 27, 2011
    Messages:
    2,474
    Likes Received:
    161
    Perfect, thanks very much!
     
    #10
    Davies Headband, Mar 31, 2013
  11. Lardarsehesford City Hull

    Lardarsehesford City Hull Member

    Joined:
    Jan 24, 2011
    Messages:
    252
    Likes Received:
    1
    I'll remember that one ! cheers MelU
     
    #11
    Lardarsehesford City Hull, Mar 31, 2013

Share This Page