I have a column list of about 3,000 which has duplicates but cannot be deleted out as each one of the columns has a unique reference to it. I need to use a vlookup function to assign a value to this set of columns, but I only want the value to appear on one of the duplicate variables....And it does matter which one.
Thanks in advance!
Lookup.PNG
Bookmarks