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

excel keys

S

sandhya

New Member
Do we have a formula or any key to check a value is repeated in a excel sheet


in case we have any shortcut key please do let me know.
 
Good day sandhya


Why not use the find feature, put your value in and press find and keep going to find all, if there is no repeated value nothing will be found.
 
If you have 2007+, you could use conditional formatting as it has an option to highlight unique/duplicate values. This would be nice for data that already exists.


To handle data that will be entered in future, we can use data validation. Say you are dealing with cell A2. Data validation, custom rule is:

=COUNTIF($A:$IV,A2)=1


Then, go to the error tab and change the drop down from "stop" to just "information", and give a pertinent message, such as "Duplicate value entered". Apply this formatting to other cells as desired.
 
You must log in or register to reply here.
Back
Top