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