Forum Discussion
prabutr28
Apr 01, 2020Copper Contributor
Using Table Headers as ranges in Data Validation
Hi Members, I have a table named "Books". My table is very simple with 3 columns. Book.ID, Book.Name, Book.Author All i want to do is to avoid duplicate values in Book.ID column of a table using d...
Branislav1984
Apr 02, 2020Brass Contributor
Hi prabutr28
Try using R1C1 reference style.
=COUNTIF($A$2:A2,A2)<2
This will also allow for growth of the table.
Hope this helps.
BR,