In a column of Data, Find 2nd, 3rd, nth occurrences and apply a value in the corresponding column

Hi all,   Attached is a spreadsheet that gives an example of what I'm working with.   In it, I'm trying to create a formula that searches all of column F for the exact same tag numbers. And if it...