Is there an easy way to locate duplicates in an Excel spreadsheet?

Question

I should add that I do not already know the data I am looking for; I only know to look for duplicates, which could be any series of numbers...

Answer 1

This may or may not be the answer to your question:

http://office.microsoft.com/en-us/excel/...

Answer 2

Say your data is in A1:A100.

To highlight any cells that match any other cell, highlight the range, then go to: >Format > conditional formatting > select: "Formula is" and input:

=COUNTIF($A$1:$A$100, A1)>1

> click "format" to choose how you want duplicates to appear.

Alternatively, you can put the same formula in a column next to your data (say, in B1:B100) and it will show TRUE or FALSE for each item.  Or take off the >1 part and it will show the # of times that each value is in your list.