• 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. I

    Conditional formatting - adjacent cells

    Yeah! Thank you so much!!! It works perfectly.
  2. I

    Conditional formatting - adjacent cells

    Hello, I have another question for using excel for a market research application. It seems very easy but I have not being able to write the formulas in the correct format to solve it or to find an answer in the forum. I need to apply several conditional formatting rules to column E so that I...
  3. I

    Return 1 value if certain criteria (including or) is met [SOLVED]

    These are a lot of new concepts in excel that I’m not familiar with (i.e. Array formula), so I will work a little bit more with all the info you guys provided. Thank you again! You have made my life much better!!! This community is great!!!
  4. I

    Return 1 value if certain criteria (including or) is met [SOLVED]

    This is awesome! Thank you all for your responses!!! I was able to get the counts using this beautiful formula that Sajan sent me: =N(SUMPRODUCT(COUNTIF(NumbersToCheck, B2:E2))>0) I added these numbers to check (1,2,3,4 & 6,7) to the range P2:U2, so the formula looks like this...
  5. I

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

    Thanks! I have just posted it as a new topic.
  6. I

    Return 1 value if certain criteria (including or) is met [SOLVED]

    Hi, I work in market research and I’m facing a problem that may seem trivial but I have not been able to resolve with a more simple formula. Open ended responses get coded into buckets that have a common theme, and then nets are created with those codes. Thus, I need to count as 1 if any of...
  7. I

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

    Hi, I also work in market research and facing a similar problem that the one you were having, but I have the codes in different cells. I'm trying to count how many cells (in the same row) have either one or both codes, and only have it count it as once if one or both codes are present. Can...
Back
Top