+ Reply to Thread
Results 1 to 3 of 3

Help with counting multiple items in a cell separated by a comma

  1. #1
    Registered User
    Join Date
    12-10-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    9

    Help with counting multiple items in a cell separated by a comma

    Hi,

    I don't really know how to explain the problem I am running into. I want the function to grab a 2 values from the 8th column that are separated by a comma.

    Here are my codes

    Please Login or Register  to view this content.

    This first code (First If Condition) works without issues, however the second code which contains "Apple, Banana" is not being counted at all. Does anyone know how to make that second set of code to work?

    Thanks
    Last edited by excelnoobies; 12-10-2012 at 10:45 PM. Reason: More accurate Title

  2. #2
    Registered User
    Join Date
    12-10-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Help with counting multiple items in a cell separated by a comma

    Anyone have an idea on how to get excel to count two different values in the same cell separated by a comma?

  3. #3
    Registered User
    Join Date
    12-10-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Help with counting multiple items in a cell separated by a comma

    Never mind, I figured out this issue. Thanks anyway!

+ 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