View Single Post
  #2  
Old April 25th, 2010, 11:55 PM posted to microsoft.public.excel.worksheet.functions
Max
external usenet poster
 
Posts: 8,574
Default Finding matches in two columns

One way using COUNTIF
In C2: =IF(B2="","",IF(COUNTIF(A:A,B2),1,0))
Copy down to the last row of data in col B. Joy? hit the YES below
--
Max
Singapore
---
"Erik" wrote:
I have two columns of years. Column A has 27 years from 1911 to 2007
indicating a particular year a house was built. Column B has all years from
1800 to 2009 use to plot a graph. In column C I want to find if any of the
years from 1800 through 2009 matchs one of the 27 years in column A and
return a 1 if that year matches or a 0 if it does not. With the results in
column C I can graph all years on the x axis and which one of them had a
house built