+ Reply to Thread
Results 1 to 9 of 9

Matching

  1. #1
    Registered User
    Join Date
    10-04-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    6

    Matching

    I am soooooo frustraited....

    Here is what I have....

    I have column "B" that contains names
    Column "C" contains a location

    I need to count how often a name repeats in in coumn "B" for each location in columns "C"

    On my data page I know I will have to have a cell with the identifies each location then in the next cell a formula that looks for that location and counts the duplicate names from column "B"

    Any help appreciated.....

  2. #2
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Complex matching problem

    Why dont u upload a sample your worksheet. It would be much easier to see your issue.

    It sounds like a sumif formula - but without seeing a better description i'm not sure
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

  3. #3
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: Matching

    Why not use a pivot table?

  4. #4
    Registered User
    Join Date
    10-04-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Complex matching problem

    Quote Originally Posted by Blake 7 View Post
    Why dont u upload a sample your worksheet. It would be much easier to see your issue.

    It sounds like a sumif formula - but without seeing a better description i'm not sure
    Hope this makes sense....

    I want to know how many john smiths are from alaska in essence

    I will need to count exact names not partial
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Matching

    See the attatch file

    hope this help
    Attached Files Attached Files
    Azam
    If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
    For prompt answer, be descriptive, concise, short, direct, and to-the-point.

  6. #6
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: Matching

    If you for some reason would prefer to have the results next to the data source, you could use (in D2 and copy down):
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    10-04-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Matching

    Azam... thanks but pivot tables are out (i'm not good with them and don;t want to make room for them,,,,

    estige was close... this is what I am looking for but the formula doesn't work as I need it too

    I've uploaded another sheet... columns G&H will end up on another sheet that gathers data... what have with the name and state is only a partial of the entire sheet, I used "states" instead of the actual data but it works the same...

    I basically need to know for each "state" how many duplicat names appear in column B...
    This is a template that names and states are added to on a regular basis, there is no set pattern e.g. steve will not be in B2 on the next sheet...

    So back to the drawing board
    Attached Files Attached Files

  8. #8
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: Matching

    I'm confused as to exactly what you are trying to achieve.
    " need to count how often a name repeats in in coumn "B" for each location in columns "C"" and
    "I want to know how many john smiths are from alaska in essence" is not the same approach as
    "I basically need to know for each "state" how many duplicat names appear in column B", which I also believe is a bit ambigous. If two names appear three times each in alabama and once in another state, what is the expected result for alabama: 2, 6 or maybe 8?

    I'm, sure it would help if you included your expected results in your workbook.
    Last edited by estige; 08-22-2011 at 06:36 AM.

  9. #9
    Registered User
    Join Date
    10-04-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Matching

    Quote Originally Posted by estige View Post
    If two names appear three times each in alabama and once in another state, what is the expected result for alabama: 2, 6 or maybe 8?

    I'm, sure it would help if you included your expected results in your workbook.
    If there are 2 "john smith" both have "alabama" in column "c" then it would count "1" for alabama....If there are 3 "john smith" with "alabama" in column "c" then it would "2"

    If there are 3 "john smith" and none have column "c" in common, then you would not count them for any state....

    If there are 2 "john smith" both have "alabama" in column "c" then it would count "1" for alabama...if there are 50 different names and only the 2 "john smith" have "alabama" in column "c" then the count would be "1"

+ 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