If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Finding matches in two columns
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. Erik (a Word and Excel 2007 user) |
Thread Tools | |
Display Modes | |
|
|