Function evaluate multiple cells and return 1st one w/a value
 

Have a table with Price & Purchases by Qtr:

A B C D
E F
QTR1$ Qtr1Vol QTR2$ Qtr2Vol Qtr3$ Qtr3Vol

Row5 $1.00 5000 $1.10 5500 $1.12 5300
Row6 $2.20 2500 $2.22
2600

Is there a function that will evaluate colum A row5 , C5, E5 and return the
first one (left to right) that has a value?

In the example above Row 5 = $1.00 and Row 6 = $2.20

The above is a very simple example but the real data will have about 20
columns to evaluate.

Function evaluate multiple cells and return 1st one w/a value
 

Hi!

Try this:

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=INDEX(A5:F5,MATCH(TRUE,A5:F5<"",0))

Biff

"Dan Shoemaker" wrote in message
...
Have a table with Price & Purchases by Qtr:

A B C D
E F
QTR1$ Qtr1Vol QTR2$ Qtr2Vol Qtr3$
Qtr3Vol

Row5 $1.00 5000 $1.10 5500 $1.12
5300
Row6 $2.20 2500
$2.22
2600

Is there a function that will evaluate colum A row5 , C5, E5 and return
the
first one (left to right) that has a value?

In the example above Row 5 = $1.00 and Row 6 = $2.20

The above is a very simple example but the real data will have about 20
columns to evaluate.