Using Data Validation to Prevent Entry of Duplicates

Wayne Winston November 22, 2017

← Back to Course Content

In this video we show how to use data validation to prevent users from entering duplicate rows in a workbook.

These are the two files needed to follow along to this video:

NO DUPLICATES START

NO DUPLICATES FINISH

Excel With Wayne is an online Microsoft Excel Training Course taught by Dr. Wayne Winston. Dr. Winston is the world’s foremost Microsoft Excel Expert that teaches at some of the world’s largest organizations including Microsoft and government organizations such as the Navy and Army.

CONTACT INFO

info@excelwithwayne.com
945 McKinney #11488 Houston, TX 77002

Facebook-f Twitter Linkedin-in

CONTACT INFO

info@excelwithwayne.com
945 McKinney #11488 Houston, TX 77002

Facebook-f Twitter Linkedin-in

Report

There was a problem reporting this post.

Harassment Harassment or bullying behavior

Inappropriate Contains mature or sensitive content

Misinformation Contains misleading or false information

Offensive Contains abusive or derogatory content

Suspicious Contains spam, fake content or potential malware

Other

Report note

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

See blocked member's posts
Mention this member in posts
Invite this member to groups
Message this member
Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .