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-25-2022, 03:19 AM

IamThatGuy IamThatGuy is offline

Mac OS X

Office 2021

Novice

Join Date: Feb 2022

Posts: 14

Quote:

Originally Posted by ArviLaanemets

Have you set only Data Validation List values to be allowed (this is a default setting, but there is a possibility to change this)?
.

Yes, I have checked that under Data validation but that does not seem to be problem.

Appreciate if you are able to check? Thank you

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 12:16 AM.