Find Duplicate Values In A Column And Identify Position In Next Column

[soltec]

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.

[Excel Fox]

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?

[soltec]

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?

VLookup would do what is needed I believe.

[ravi.45kumar]

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