Home

12 Feb, 2008

Excel Tweaks: Excel Formula to find Duplication of Cells

Posted In: Tips Tricks

share this

  • Technorati
  • del.icio.us
  • StumbleUpon

Learn Excel .. :)

Identify Duplicate Cells in Excel using this formula

=IF(MAX(COUNTIF(A1:A10,A1:A10))>1,”Duplicates”,”No Duplicates”)

Just copy this formula on the cells if you have to find all the data’s in a long single column.

Tags: ,
  • Digg
  • Reddit
  • del.icio.us
  • StumbleUpon
  • TwitThis
  • E-mail this story to a friend!

No Responses to "Excel Tweaks: Excel Formula to find Duplication of Cells"

Subscribe to Comment follow up

Comment Form

Spam protection: Sum of 4 + 9 ?

Trackbacks

Site Structure

  • (Please don't forget to 'Activate' the email subscription from your Inbox!)

  • Increase IE speed
  • Wikipedia going to hit 3 million Articles | 2009
  • How to change the Registered Name and Company in the System Properties dialog Box?
  • Creating Emergency Boot up Rescue Disk
  • Problem on Opening a folder via Right-Clicking
  • Shop Smart Buy or Sell Shopping Products Smartly | Teach Shopping to Children
  • Windows XP Problem | System will close after a countdown of 50 Seconds



    • Hot Discussion is proudly powered by WordPress

    e Hot Discussion | Brings you the Hot Topics

    No future events scheduled.

    Follow me on Twitter