Screening one list for data
 

I'm such a newbie, I thought this would be embarassingly easy but two hours
later...hopefully someone can help! I have two long lists of values; in list
#1, there are about 800 unique values, whereas in list #2, there are 366
unique values. I want to be able to identify which values can be found in
both lists, but have failed to master COUNT/LOOKUP/etc. Would love any
suggestions.

Screening one list for data
 

Sort both ascending. Up till the first row there is a difference they
are same. You can check that with a support column:
=if(A1=B1,1,0)

When you see the first 0, anything above it is identical.


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=533037

Screening one list for data
 

Hi!

One way:

Assume list1 is in A1:A800 and list2 is in B1:B366.

Enter this formula in C1:

=IF(COUNTIF(A$1:A$800,B1),"in both lists","")

Copy down to C366 (double click the fill handle for quick copying)

Biff

"DD" wrote in message
...
I'm such a newbie, I thought this would be embarassingly easy but two
hours
later...hopefully someone can help! I have two long lists of values; in
list
#1, there are about 800 unique values, whereas in list #2, there are 366
unique values. I want to be able to identify which values can be found in
both lists, but have failed to master COUNT/LOOKUP/etc. Would love any
suggestions.