Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two ranges and the positions of duplicates
Is is possible to compare two ranges and return a list of booleans
illustrating where the values in 1 range reside in the other. Assume Range 1 is as follows (A1:A10): Dog Cat Man Women Car Rain Black In Peter Acid Assume Range 2 is as follows (B2:B6): Rain Blue Mary Stick Dog I want the result to illustrate where the items in Range 2 reside in Range 1 as follows. {1,0,0,0,0,1,0,0,0,0} showing that both "Rain" and "Dog" reside in Range 1 in positions 1 and 6. Any ideas? Thanks EM |