View Single Post
  #3  
Old April 26th, 2010, 12:51 AM posted to microsoft.public.excel.worksheet.functions
Erik
external usenet poster
 
Posts: 110
Default Finding matches in two columns

Max, You are a genius and many thanks. Would you also be so kind to explain
what is going on using IF and COUNTIF? Thanks,
Erik
--
Erik (a Word 2007 user)


"Max" wrote:

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