find any unique number from column on one sheet, put in cell(s) on another

Hi Ag-QA,

Use DataFilterAdvanced Filter.

Select Copy to another location.
Enter that location in the Copy to box.
Select Unique records only.

Biff

-----Original Message-----
Help. I'm trying to get any unique number from a column
of numbers on
one sheet, and put that number in a cell(s) on another
sheet. Example:

0
0
2
4

needs to show up as

0
2
4

This is OK, but

0
0
0
shows up as

0
0
0

and not just

0

I'm using formula:
=IF(ISERROR(TRANSPOSE(uniqueitems('All Individual animal
data'!P8:P10,FALSE))),"",TRANSPOSE(uniqueitems('A ll
Individual animal
data'!P8:P10,FALSE)))



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

.

Thanks for the reply Biff.
The problem with the fix you suggested is that the copy will not work
from one sheet to another. It will copy only to the same active
sheet.
I'm so close, but cannot get it to give me only one uniqueitem if all
the numbers in the column are the same. If all are 0's, then I get
0,0,0. If all are 0's and 2's, then I get 0,2. Not 0,0,2. So why
can't I get just 0 instead of 0,0,0?


"Biff" wrote in message ...
Hi Ag-QA,

Use DataFilterAdvanced Filter.

Select Copy to another location.
Enter that location in the Copy to box.
Select Unique records only.

Biff

-----Original Message-----
Help. I'm trying to get any unique number from a column
of numbers on
one sheet, and put that number in a cell(s) on another
sheet. Example:

0
0
2
4

needs to show up as

0
2
4

This is OK, but

0
0
0
shows up as

0
0
0

and not just

0

I'm using formula:
=IF(ISERROR(TRANSPOSE(uniqueitems('All Individual animal
data'!P8:P10,FALSE))),"",TRANSPOSE(uniqueitems('A ll
Individual animal
data'!P8:P10,FALSE)))



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

.

"Biff" wrote in message ...
Hi Ag-QA,

Use DataFilterAdvanced Filter.

Select Copy to another location.
Enter that location in the Copy to box.
Select Unique records only.

Biff

I'm using formula in A45:A47
=IF(ISERROR(TRANSPOSE(uniqueitems('All Individual animal
data'!P8:P128,FALSE))),"",TRANSPOSE(uniqueitems('A ll Individual animal
data'!P8:P128,FALSE)))

where P8:P128 = 0,2,0,0,0,0,...
I get in A45:A47 = 0,2 (these are the unique items from P8:128)

where P8:P128 = 0,2,4,0,0,0,...
I get in A45:A47 = 0,2,4

where P8:P128 = 0,0,0,0,0,0,...
I get in A45:A47 = 0,0,0

But shouldn't I only get one in A45 = 0
Instead of three (A45 =0, A46 =0 and A47=0)?