• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    multiple values in a cell; count cells only once if have both of 2 val [SOLVED]

    It works just fine--thank you so much! It even works with three different codes, as follows: =SUMPRODUCT(--((ISNUMBER(SEARCH("FRND",Q3Answrs)))+(ISNUMBER(SEARCH("COMMUN",Q3Answrs)))+(ISNUMBER(SEARCH("SOCGRP",Q3Answrs)))>0)) Now, of course, I'm curious *how* it works. I am starting to get...
  2. C

    multiple values in a cell; count cells only once if have both of 2 val [SOLVED]

    Thanks for the reply--I will try it tomorrow. It is fairly late at night right now where I am! Will let you know if it works!
  3. C

    multiple values in a cell; count cells only once if have both of 2 val [SOLVED]

    Hello: First off, let me say a great, big, huge thank you to everyone involved in this site! What a fantastic resource it is, and I really appreciate the time taken by those who are willing to answer questions on the forum. I am rather a newbie to excel, having mastered very simple formulas...
Back
Top