Quote:

Originally Posted by

**dcg**
Here's a question for the OP (or anyone else that might feel like answering).

Say you have a list of a few thousand cells that you need deduped. Ex:

1

1

2

5

10

13

13

13

16

22

....

Assume your list starts in A2. When I've had to accomplish this I've entered

=IF(A2=A1, 1, 0)

into B2, then copied -> paste special -> values both columns, then sorted both columns by column B ascending, giving you a deduped list in column A for all rows where column B is 0.

Is there an easier way to dedupe a list?

I would modify the first formula I posted:

{=INDIRECT("A"&SMALL(IF($A$2:$A$15<>$A$1:$A$14,ROW($A$2:$A$15)),ROW(A1)))}

Drag down.