Unique values within a list

[Steven L]

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?

 

[Gary''s Student]

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??

 

[Steven L]

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.

 

[Debra Dalgleish]

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 Data>Filter>Advanced 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