Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation and Blanks in List | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
Loop through email address list to send e-mails | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |