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
use below formula for the data validation for desired range. Change all the "B"s to fit your need.
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
Please check the attached file.
Thanks it works like a charm. Thank you kindly
Best regards Bengt
@erol sinan zorlu
@Gubbedelux lease mark this as best solution.