Excel 2010 - Stacked Column (Duplicates)

I have a stacked column of numbers (10, 1058, 1090, 1090, 1328....) and I want to be able to see where my duplicates are with an added indentifier in the column to the right.  How do I accomplish this?
rgarzakavoAsked:
Who is Participating?
 
Nico BontenbalConnect With a Mentor Commented:
If you have a list of values in column A starting at row 1 enter this formula in cell B1:
=IF(ISERROR(VLOOKUP(A1,A2:A$1000,1,FALSE)),"","duplicate")

Open in new window

and copy the formula down.
0
 
Nico BontenbalCommented:
You could use a Vlookup in column B that tries to find the value in column a in all the rows below the current row.
0
 
rgarzakavoAuthor Commented:
LOVE IT!  Thnx
0
 
jimenezCommented:
You can use conditional format, and use the find duplicates rule.
Once you do this, you can sort the values based on the format you use at the conditional format.
0
 
rgarzakavoAuthor Commented:
jimenez
Nice to know and I like that feature but the answer provided by Nicobo better suited my needs in this instance.
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.