Take all unique values in sheet and place in 1 column
 

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.

Take all unique values in sheet and place in 1 column
 

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.

Take all unique values in sheet and place in 1 column
 

We imagine to limit search, highlight used range first

for each cell in selection
if isnumeric(cell) then newsheet.cells(rows.count,1).end(xlup)(2)=cell
next cell

newsheet.activate
columns(1).sort ascending
from bottom up,
delete duplicates

--
Regards

"CompleteNewb" wrote in message
...
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.

Take all unique values in sheet and place in 1 column
 

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook you can use
something like

arr = ArrayUniques(Sheets("Sheet2").UsedRange)
Sheets("Sheet3").Range("A1").Resize(UBound(arr), _
UBound(arr, 2)).Value = arr

Alan Beban

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.

Take all unique values in sheet and place in 1 column
 

Todd:

Searched it, found it, added it, and damned if you're not totally on point;
that add-in is awesome. I intend to make a donation to that person.
Hopefully I'll figure out what kind of donation will allow me to look at the
VBA, so I can adapt to future needs.

Thanks everyone who responded, it is much appreciated.

Complete Newb


wrote in message
ups.com...
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.