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

Make each column unique

N

neeraj2050

Member
Greetings!!

I have different columns and I want to make each column unique. For that I have to select each column one by one

Is there is any solution so that entire column could be made unique

Note : Not looking for solution like : select entire column at once and then it will make rows unique. I want to make each column unique and none of them are interrelated though into the same sheet

Regards
Neeraj Kumar Agarwal
 
If you are trying to ensure that the data entry should impose unique values in that column..then we can take the help of data validation..

For example, in a worksheet I want to ensure that the range A1 to A10 contains unique values, for that I have create a data validation rule as follows in these group of cells..

Code: 
=COUNTIF($A$1:$A$10,A1)<=1

The above rule ensures that the values entered by user in these group of cells are unique..
 
You must log in or register to reply here.
Back
Top