I've recently started working at a job where data input takes up most of my intern's day and I wish to make their lives (and my own) easier. I'm trying to build a new spreadsheet where duplicates (phone numbers and/or e-mails) that were entered before in previous entries would be automatically detected and the Ref Code show up in another column. English is not my first language and what I've said is a little confusing, so I've attached a screenshot of the set up I have now and what I'm trying to do (highlighted in red in the pic) below:
\1
If anyone can help me, I would be very grateful.
Bookmarks