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.
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
> Let's say the numbers were one column and the words were another.
>
[quoted text clipped - 24 lines]
>>>a larger list. (multiple columns) How do I identity unique values in that
>>>specific column but pull out the entire row?

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