Unique values within a list
 

I would like to find unique values in a column, however the column is within
a larger list. (multiple columns) How do I identity unique values in that
specific column but pull out the entire row?

Unique values within a list
 

If we have:

1 cat
1 dog
2 rat
2 bat
3 flea
3 tree
4 orange
4 apple


Do you want the 1 cat row or the 1 dog row??
--
Gary''s Student - gsnu200789


"Steven L" wrote:

I would like to find unique values in a column, however the column is within
a larger list. (multiple columns) How do I identity unique values in that
specific column but pull out the entire row?

Unique values within a list
 

Let's say the numbers were one column and the words were another.

I want to get unique numbers, but I want want the row associated with the
unique number. Such as:

1 cat
2 rat
3 flea
4 orange

I assume Excel would take the first matching number.

"Gary''s Student" wrote:

If we have:

1 cat
1 dog
2 rat
2 bat
3 flea
3 tree
4 orange
4 apple


Do you want the 1 cat row or the 1 dog row??
--
Gary''s Student - gsnu200789


"Steven L" wrote:

I would like to find unique values in a column, however the column is within
a larger list. (multiple columns) How do I identity unique values in that
specific column but pull out the entire row?

Unique values within a list
 

To extract the first row for each unique number, you can use an Advanced
Filter:

Add a heading row to your list
To create a criteria range:
Leave cell E1 blank
In cell E2, type: =COUNTIF($A$1:A2,A2)=1
Select a cell in the list
Choose DataFilterAdvanced Filter
Select Copy to Another Location
For the List Range, your list's range should be automatically selected
For the Criteria Range, select E1:E2
For the Copy To range, select cell H1
Click OK


Steven L wrote:
Let's say the numbers were one column and the words were another.

I want to get unique numbers, but I want want the row associated with the
unique number. Such as:

1 cat
2 rat
3 flea
4 orange

I assume Excel would take the first matching number.

"Gary''s Student" wrote:


If we have:

1 cat
1 dog
2 rat
2 bat
3 flea
3 tree
4 orange
4 apple


Do you want the 1 cat row or the 1 dog row??
--
Gary''s Student - gsnu200789


"Steven L" wrote:


I would like to find unique values in a column, however the column is within
a larger list. (multiple columns) How do I identity unique values in that
specific column but pull out the entire row?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html