Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

Unique values within a list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steven L - 29 May 2008 17:22 GMT
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 - 29 May 2008 17:44 GMT
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??
Signature

Gary''s Student - gsnu200789

> 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?
Steven L - 29 May 2008 18:50 GMT
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.

> If we have:
>
[quoted text clipped - 12 lines]
> > a larger list. (multiple columns) How do I identity unique values in that
> > specific column but pull out the entire row?
Debra Dalgleish - 29 May 2008 19:27 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.