Hello,

Here is the ARRAY Formula I have and this is what I am using it for.
The situation is that it worked 1 time and than not again.

=INDEX(D48:K48,,MAX(IF(D48:K48<"",COLUMN(D48:K48) ))-COLUMN(D48)+1


Duty:

I have a row of number that appear hourly (DOLLAR AMOUNTS), the number
are anything from nothing to 10000. I want the hourly number to appear
in specified cell. Here is an example. (I am using EXCEL 2000)

Row D48:K48 answer in cell G2


1st hour
D48 = $100.00 G2 Should be $100.00

2nd Hour
D48 = $100.00 E48 = (nothing) G2 Should be (nothing)

3rd Hour
D48 = $100.00 E48 = (nothing) F48 = $230.00 G2 Should be $230.00

4th Hour
D48 = $100.00 E48 = (nothing) F48 = $230.00 G48 = $56.00 G2 Should be
$56.00

5th Hour
D48 = $100.00 E48 = (nothing) F48 = $230.00 G48 = $56.00 H48 = $456.34
G2 Should be $456.34

6th Hour
D48 = $100.00 E48 = (nothing) F48 = $230.00 G48 = $56.00 H48 = $456.34
I48=(nothing) G2 Should be (nothing)

7th Hour
D48 = $100.00 E48 = (nothing) F48 = $230.00 G48 = $56.00 H48 = $456.34
I48=(nothing) J48=$789.52 G2 Should be $789.52

8th Hour
D48 = $100.00 E48 = (nothing) F48 = $230.00 G48 = $56.00 H48 = $456.34
I48=(nothing) J48=$789.52 K48= $45.67 G2 Should be $45.67

As I said this array formula worked 1 or 2 times and than nothing. (I
did do the cntrl+shift+enter)

What shows in G2 now is Blank the cell is blank, nothing

I have tried to retype it and cntrl+shift+enter. Nothing !!!

Can someone help me

flapokey :(


--
flapokey
------------------------------------------------------------------------
flapokey's Profile: http://www.excelforum.com/member.php...o&userid=26690
View this thread: http://www.excelforum.com/showthread...hreadid=466819