• 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

    Referencing range with column heading

    Select the Range or column which you want to count In the name box (It is just left to formula bar) define the range you selected, like "Age" and press enter The Use the Formula =countif(age,">=65")
  2. S

    Compare columns and highlight unique values

    =if(sumproduct((A1:G6=A1)*1)>1,"Duplicate","Unique")
Back
Top