Hi.
This time I table like this
2002 2003 2004 2005 2006
$32,000 $45,000 $65000 $100,000 $1,000,000
This table shows my expected earnings when I master excel :wink:
In this table, the years are fixed. However, the amounts are determined by formulas and change when you change the inputs in some other cells not in that table.
However, this is what I need.
I need a quick way of getting a cell to display the year when the earnings have exceeded $50,000 say.
In this example, the formula would give us the year 2004.
I know someone out there knows an elegant solution, probably to do with index etc.
Thanks guys,
RET79
This time I table like this
2002 2003 2004 2005 2006
$32,000 $45,000 $65000 $100,000 $1,000,000
This table shows my expected earnings when I master excel :wink:
In this table, the years are fixed. However, the amounts are determined by formulas and change when you change the inputs in some other cells not in that table.
However, this is what I need.
I need a quick way of getting a cell to display the year when the earnings have exceeded $50,000 say.
In this example, the formula would give us the year 2004.
I know someone out there knows an elegant solution, probably to do with index etc.
Thanks guys,
RET79