Someone take a quick look please

[lorenzoc]

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!

[TABLE="width: 672"]
<tbody>[TR]
[TD] P2012 [/TD]
[TD] P2011 [/TD]
[TD] P2010 [/TD]
[TD] P2009 [/TD]
[TD] P2008 [/TD]
[TD] P2007 [/TD]
[TD] P2006 [/TD]
[TD] P2005 [/TD]
[TD] PPre2004 [/TD]
[/TR]
[TR]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] 28,865 [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD] 5,453 [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD] (75,702)[/TD]
[TD] 1,039,499 [/TD]
[TD] 2,826,499 [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
</tbody><colgroup><col span="2"><col><col><col><col span="2"><col><col></colgroup>[/TABLE]

 

[schielrn]

Welcome to the board!

What are your expected results for this data set you have shown? Are you wanting one formula per row to the right of your data set? And I'm not positive I understand what you want returned.

 

[Sk123]

dont you think pivot table will help you?