Count all Unique Excel Cells or Entries with this Formula.

Posted on February 20, 2008 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

Computer Tips, Tricks, Tweaks and Tutorials - Count all Unique Excel Cells or Entries with this Formula.

Today’s Microsoft Excel Formula is an addition to several others that we discussed earlier. We talked about an Excel Formula for avoiding duplicate content, I showed you how to generate a column with only unique entries in it and I also showed you how to create a formula to count all the cells with data in it. Today’s MS Excel Tip and Trick is kind of similar to the last one.

 

If you don’t want to create a column with only unique data then it’s also possible to count all the cells with unique data in it.

 

A formula to count all the Excel cells with unique data or names in it.

 

  • First you need to highlight your entries

 

Excel-tip-trick-pic1

 

  • Then select Cell A11
  • And type in this formula =SUM(IF(A1:A10<>"";1/COUNTIF(A1:A10;A1:A10)))

 

Excel-tip-trick-pic2

 

  • Then click on CTRL+SHIFT+ENTER

 

Excel-tip-trick-pic3

 

And you’re done; I hope you all have enjoyed this Excel Tip and Trick; I’ll talk to you all tomorrow.

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 10 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

2 Responses to “Count all Unique Excel Cells or Entries with this Formula.”

  1. Kanchan on May 30th, 2008 2:07 pm

    I am looking for formula such as Column A minus Column B equall to column C
    I am beginer Kindly help

  2. Kanchan on May 30th, 2008 2:09 pm

    what is the other method

Leave a Reply