Quote:

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?

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?

In Excel 2007 it's just Data=>Eliminate Duplicates, I assume you're using a previous version where that does not exist.