multiple validation on a column to avoid duplicate entries

IamThatGuy · #6 02-23-2022, 08:52 AM

Quote:

Originally Posted by kilroyscarnival

I've applied a numbering column where the column's cells are locked, and where the numbers don't show up until he starts to type content in the next (B) column.

First number cell =IF(B2="","",1)
Subsequent number cells =IF(B3="","",MAX(A$2:A2)+1)
The latter, when filled down, becomes =IF(B17="","",MAX(A$2:A16)+1) etc.

Thanks for this but this does not work if someone decides to insert a line in the middle of the data

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