multiple validation on a column to avoid duplicate entries

		Microsoft Office Forums > Microsoft Excel > Excel
multiple validation on a column to avoid duplicate entries

02-22-2022, 07:51 AM

IamThatGuy IamThatGuy is offline

Mac OS X

Office 2021

Novice

Join Date: Feb 2022

Posts: 14

multiple validation on a column to avoid duplicate entries

In the attached, tab 'Working'...

is there a way to:

Add validation so duplicate entries are not allowed. Would normally use Data validation for this but this is already being used
Restrict users from typing into column A. i.e. be forced to use the Drop down only

Thank you in advance

Attached Files

IDExample.xlsx (14.4 KB, 10 views)

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to avoid duplicate table headers while mail merge records?	everwisher	Mail Merge	2	01-04-2019 04:50 AM
Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell?	jsisley	Excel	1	07-21-2017 09:20 AM
Duplicate entries	yourforester	Outlook	1	11-15-2014 10:44 PM
Calendar - Duplicate Entries	castow	Outlook	0	02-05-2014 02:53 PM
How Can I Flag Duplicate Date Entries?	tatihulot	Excel	5	11-16-2012 12:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:22 PM.