Sep 04 2019 03:37 AM
Im trying to made a formula thats preventing duplicate entries in my worksheet. I want to check table A from position 8 to 3000 and give the user a varning message if a duplicate occurs.
Have tried videos from youtube but they did not work. A message allways pops up and till me to use an apostrophe in the beginning of the formula. PLEASE HELP
Bengt from Sweden
Sep 04 2019 04:01 AM - edited Sep 04 2019 04:02 AM
use below formula for the data validation for desired range. Change all the "B"s to fit your need.
=COUNTIF($B$1:$B4;"="&B4)=1
Sep 04 2019 06:08 AM
Thanks for you response. Another message poptup that says. ONE OF THE AREAS YOU MENTIONED COULD NOT BE FOUND. Do you have any other idea?.@erol sinan zorlu
Sep 04 2019 10:28 PM
Please check the attached file.
Sep 05 2019 08:54 AM
Sep 05 2019 11:42 AM
@Gubbedelux lease mark this as best solution.