I know there is a way to use an array formula for this. Essentially I have data ranging over a 9 year period. The data starts in certian years and ends in others. I want to write a formula that would say if the data starts in 2008 or later show the numbers, if not show zero or n/a. Here is an excerpt for my data below. So an formula I could put in on the right colunm past PPre2004 that would either return a number or not. thanks guys and girls!
<tbody>
</tbody><colgroup><col span="2"><col><col><col><col span="2"><col><col></colgroup>
P2012 | P2011 | P2010 | P2009 | P2008 | P2007 | P2006 | P2005 | PPre2004 |
- | - | - | - | - | - | - | 28,865 | - |
5,453 | - | - | - | - | - | - | - | - |
(75,702) | 1,039,499 | 2,826,499 | - | - | - | - | - | - |
- | - | - | - | - | - | - | - | - |
- | - | - | - | - | - | - | - | - |
<tbody>
</tbody><colgroup><col span="2"><col><col><col><col span="2"><col><col></colgroup>