|re: I want the next column to state "Non Duplicate"|
Do us a favor and make believe that you are us and not you. Make believe you can't see your spreadsheet from where you are sitting. Then go back and read what you posted.
Do you think you could offer any assistance?
Based on what you have posted, the easy answer is to tell you just enter the text in the next column, but I am sure that is not what you are looking for.
How about sharing what criteria would result in "Non Duplicate"? What formula are you trying?