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

    Help with list, checking total

    Hi, I am having a problem with my list of data. Here is the back ground the figure provided in column E is the total number of leaflets that I received , i want to ensure that no individual (listed in column A) gets less than 5. I also want to ensure that the overall total of column B is...
  2. S

    If statement problem

    Hi, I get a zero as the result of this formula when I was expecting the answer Yes (my test answer) Here is the formula =(IF(C5<=5,(5),IF(B$46<0,"YES","No"))) Data C5 = 6 B46 = -78 Now in the cell the formula is in, lets say B5 returns 0 if the first IF...
  3. S

    Compare columns and highlight unique values

    Hi, This is my first posting. I have two columns of data which I need to compare in order to find those values which do not appear in either column. Once found I intend using conditional formating to highlight those values which are not duplicated in either column. For example Column A...
Back
Top