+ Reply to Thread
Results 1 to 2 of 2

Select a range based on a cell value

  1. #1
    Registered User
    Join Date
    05-24-2013
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Select a range based on a cell value

    Hi

    I have a spreadsheet where we input data from answers given from an evaluation of sports sessions that the company I work for runs. Just for the sake of this question, lets assume I have two columns. Col A is a list of sports that our clients mentioned that they participate in. Col B is a list of their genders (M,F). How could I select a range that only involves the males and one for females. My main goal is to count how many times each gender participated in each sport. For example I would like to count how many of the females played football. So I would like a formula to count how many times football was mentioned in Col A if the value in col B is "F".

    Hope that makes sense
    Thank you.

  2. #2
    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,929

    Re: Select a range based on a cell value

    Is this a continuation of this thread?
    http://www.excelforum.com/excel-form...ific-text.html

    Im sure the solutions offered in your other thread would would for you on this too?

    What I would do would be to create a table with all unique sports in 1 column, M in the next etc, then use a countifs() to give you what you need
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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