+ Reply to Thread
Results 1 to 4 of 4

Using Frequency Formula to find frequency of number 1s, if row has Specific Location "USA"

  1. #1
    Registered User
    Join Date
    09-11-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    30

    Using Frequency Formula to find frequency of number 1s, if row has Specific Location "USA"

    I have a spreadsheet with the following columns:

    Name Location Rating If
    Joe Canada Target 2
    Fred Canada Below Target 3
    James France Above Target 1
    Mary UK Target 2
    Sam USA Above Target 1
    Jane USA Above Target 1

    On the next three sheets I have the following tables created to populate graphs using the values from the frequency equation for the number of ratings for each Location.

    Rating Value Frequency
    Below Target 1
    Target 2
    Above Target 3

    For the first sheet I am using the Frequency formula to populate how many 1s are on the first spreadsheet and how many 2s and 3s for Canada

    But I have to sort the first spreadsheet by the location column and only include the rows with Canada as a location.

    Is there a way that I can populate the frequency formula to search all rows in the first spreadsheet and return the number of 1s, 2s 3s for a specific location? If the first spreadsheet is sorted another way the graphs will be incorrect.

    Hope this is clear. I have attached a sample file Excel Location_Rating Graph tabs.xlsx


    Thanks

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,901

    Re: Using Frequency Formula to find frequency of number 1s, if row has Specific Location "

    Create a pivot table
    And then make the graph from a pivot table
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    09-11-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Using Frequency Formula to find frequency of number 1s, if row has Specific Location "

    The data will likely change does this translate to the pivot table data? Or will I have to create the pivot table everytime?

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,901

    Re: Using Frequency Formula to find frequency of number 1s, if row has Specific Location "

    Pivot table don't update automaticaly
    Do it manually (button) or it can be done with VBA

+ 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] problem with "frequency" function
    By ck_123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-24-2013, 10:42 AM
  2. [SOLVED] "Anti-aggregate/frequency"-table
    By jpar in forum Excel General
    Replies: 4
    Last Post: 05-29-2012, 09:21 AM
  3. [SOLVED] Productsum: Highest Frequency Category, Specific Main Category, Frequency of Category
    By T86157 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-24-2012, 12:43 PM
  4. Formula to find frequency of use
    By Intern13 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-09-2010, 04:19 PM
  5. Find specific number and replace with "Yes"
    By DW in forum Excel General
    Replies: 1
    Last Post: 04-26-2006, 04:25 PM

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