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

    Nested IF statements for 3 conditions and multiple outcomes? or COUNTA?

    Please try below formula: =IF(COUNTIF(A2:C2,"NO")=3,"n/a",IF(A2<>"NO",A$1&" @ "&A2,"")&IF(B2<>"NO",B$1&" @ "&B2,"")&IF(C2<>"NO",C$1&" @ "&C2,""))
  2. A

    Hello .. Introduce yourself

    Namaskar, Ajit Chauhan from India. I want to be awesome in Excel with help of this forum because Excel is my favorite subject.
  3. A

    color cell under condition

    Hi, If you want to compare two columns (A & C). First select range of column "C" then select range of column "A", now click F5 for Go To Special and click on Row differences, press OK button and click on fill color.
  4. A

    numbering for top 3 highest and lowest value with comment

    Hi Ajinkya, This is my first post, i hope you will like below solution, if there is any error please suggest: =IF(IF(B2>0,RANK(B2,$B$2:$B$9),RANK(B2,$B$2:$B$9,1))>3,"",IF(B2>0,RANK(B2,$B$2:$B$9)&" Gain",RANK(B2,$B$2:$B$9,1)&" Loss")) Use above formula in cell c2 and drag down.
Back
Top