Go to Google and type "Duplicate Master" and click on the first link
that appears...when you see a picture of a baby in a Santa's hat
download that plug in...I know this sounds weird but this is truly one
the better duplicate finding programs I have seen for Excel.

Hope that helps!

-Todd



CompleteNewb wrote:
This was a task that I thought I'd be able to do real easy, but am
apparently incapable.

I have a sheet with values everywhere, I mean just EVERYWHERE. No
organization in terms of rows, columns, etc. Just stuff like a value in A6,
L4, A10, K116, X65, etc. It's a long story, PLEASE don't ask :)

What I'd like to do is just take unique values from every cell on the sheet
and place them in one specified column. In fact, if it's too difficult, I
don't need to only get DUPLICATE values, I can just delete duplicates in the
finished column once everything's there.

Does anyone know how to accomplish this? I tried adapting several different
macros I have into a kind of "FrankenMacro" thing, but nothing worked.

Any help on this would be GREATLY appreciated, and thanks for taking the
time.