Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return true if multiple cells are the same | Excel Discussion (Misc queries) | |||
Function won't return value in merged cells | Excel Discussion (Misc queries) | |||
IF function....testing against values in multiple cells | Excel Worksheet Functions | |||
Return data from multiple cells | Excel Worksheet Functions | |||
Function to look at two cells and return a third | Excel Worksheet Functions |