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

  • Thread starter Thread starter Ag-QA
  • Start date Start date
A

Ag-QA

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('All Individual animal
data'!P8:P10,FALSE)))
 
Hi Ag-QA,

Use Data>Filter>Advanced Filter.

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

Biff
 
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 said:
Hi Ag-QA,

Use Data>Filter>Advanced Filter.

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

Biff
Click to expand...
I'm using formula in A45:A47
=IF(ISERROR(TRANSPOSE(uniqueitems('All Individual animal
data'!P8:P128,FALSE))),"",TRANSPOSE(uniqueitems('All 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)?
 
Back
Top