Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to test in duplicates entries in a column without sorting ?

Microsoft Excel Computer Science Microsoft Office Computer Skills
user-image
Question added by Shady Ali - CMA , Senior Accountant , Smart Code for business services
Date Posted: 2016/08/15
Upvote (0) Views (5) Followers (3) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Firas Shahadi
by Firas Shahadi , Human Resources Director , SAUDI UNION

use countif()

and to make it more interesting mere it with conditional formating.

 

Deleted user
by Deleted user

You can use COUNTIF formula in next column and it will show you the duplicates as "2" and "1" as unique entry.

Write Your Answer
More Questions Like This