Thank you for your assistance. It is greatly appreciated.
I have a spreadsheet with over 6,000 items and many are string duplicates that I need to identify and label
Example:
abc dup 1
abc dup 1 Unique ID
123 dup 2
123 dup 2
456 non dup
678 non dup
890 non dup
cycling through all cells in a particular column.
Hi soltec. Welcome to the ExcelFox community.
Could a formula based solution work (one solution provided), or would you need to do this using VBA?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
VLookup would do what is needed I believe.Originally Posted by Excel Fox
Data Output
abc Dup1
abc Dup1
123 Dup2
123 Dup2
456 Non Dup
678 Non Dup
890 Non Dup
886 Non Dup
123 Dup2
Apply below formula in B column which is output column with CSE
=IF(COUNTIF($A$2:$A$10,A2)>1,IF(COUNTIF($A$2:A2,A2 )=1,"Dup"&MAX(IFERROR(SUBSTITUTE($B$1:B1,"Dup","") *1,0))+1,"Dup"&MAX(IFERROR(--SUBSTITUTE("Dup"&$B$1:B1,"Dup",""),0))),"Non Dup")
apply formula with Ctrl+Shift+Enter in b2 and drag down
Posting Permissions
Reply With Quote
Bookmarks