Hi there. I have a large amount of data to input in the format "XXX" where X takes any letter. I do not want repeats so have used the custom formula =COUNTIF($A$1:$AS$204,A1)=1 in data validation. This will pick up the repeats but i want a way to automatically rename an entry put in. Example "abc" will become "abc1" if abc has already been inputed.
Hope this makes sense. Thanks in advance
Hope this makes sense. Thanks in advance