Hi, I need to create unique ID reference numbers if duplicates are found. Please see attached pic:
urn.png
Could I add a formula to compare Column D (generated Ref No) with Column E (All existing Ref Nos) to output a unique Ref no in Column F?
A B C D E F
1 REF INTIALS FIRST NAMES SURNAME GENERATED REF NO ALL REF NOS UNIQUE REF NO
2 AW ADAM WILLIAMS AW-0000 AW-0001 AW-0007
3 AW-0002
4 AW-0003
5 AW-0004
6 AW-0005
7 AW-0006
The last for digits are numeric and I would like the numbers to increase sequentially.
I'm a novice and would really appreciated the help.
Thx
Bookmarks