Here's one way.

Let's say your data is in A1:A11000, with headers in row 1

1. Sort your data by column A (ascending)
2. Place the formula "=COUNTIF($A2:$A$11000,A2)=1" in cell B1 and fill
down
3. Sort your data by column B
4. You can delete all the rows that say "FALSE" in column B, those are
the dupes

I tested this on a small sample and it worked well.

Remember you must sort ascending first otherwise you can miss out on
some dupes.

HTH,
JP

On Dec 13, 1:37 pm, cd_gilbert
wrote:
I have about 11,000 documents listed in a worksheet that are individually
numbered, and want find duplicate entries in the worksheet. I need to create
a formula that will allow me to see ONLY the duplicates.