# Counting frequency of individual words

1. ## 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. ## Re: Counting frequency of individual words

Can't you use a pivot table?

3. ## 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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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