+ Reply to Thread
Results 1 to 3 of 3

Counting frequency of individual words

  1. #1
    Registered User
    Join Date
    08-28-2013
    Location
    Aberdeen
    MS-Off Ver
    Excel 2007
    Posts
    2

    Counting frequency of individual words

    Hi All,

    Having a little bit of an issue figuring out a formula...

    I am working on a database of airline costs and one of the fields I am looking to auto populate from the data table is number of suppliers. This works fine and am using the formula =SUM(IF(FREQUENCY(MATCH(B2:B10,B2:B10,0),MATCH(B2:B10,B2:B10,0))>0,1)) to do so. The issue is though I have another criteria for selection to add to this; that of office of use. We have 5 different offices (Glasgow, London etc...) and the number of suppliers for each office also has to be determined. Each line of data has an office code attached (GE for Glasgow, LE for London etc....)

    I can do this manually by splitting each offices data up onto different sheets and then applying the above formula, but would rather have a formula that would do this automatically thus saving time. Was thinking it would be a case of nested IF statement but struggling to come up with the right answer. Any help with this would be greatly appreciated.

    Joe

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: Counting frequency of individual words

    Can't you use a pivot table?

  3. #3
    Registered User
    Join Date
    08-28-2013
    Location
    Aberdeen
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Counting frequency of individual words

    My excel skills are a little piecemeal having only learned bits and bobs as and when. I've designed a balanced scorecard which is where this information will be contained in and would like to build the functions into the cells within this scorecard. Once the data is loaded onto a seperate sheet then the cells would auto-populate with the information. I have very little experience of pivot tables and although I'm sure it would probably work I would prefer to have a formula that would do this.

    But granted I probably need to spend some time working with pivot tables.

+ 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. [SOLVED] counting occurrence of specific words in another group of words
    By kh@horsemanship101.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2021, 07:33 PM
  2. list of words by frequency
    By mcdermott2 in forum Word Formatting & General
    Replies: 1
    Last Post: 08-02-2013, 03:37 PM
  3. [SOLVED] Trying to sum frequency of duplicated words
    By jackorres in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-16-2013, 02:46 AM
  4. ordering words by frequency
    By mogwai1968 in forum Excel General
    Replies: 3
    Last Post: 08-14-2011, 08:59 AM
  5. [SOLVED] 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