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?
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:

Open in new window

and copy the formula down.
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.
rgarzakavoAuthor Commented:
LOVE IT!  Thnx
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.
rgarzakavoAuthor Commented:
Nice to know and I like that feature but the answer provided by Nicobo better suited my needs in this instance.
Thank you.
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.