HELP!!! I need HELP with a array formula PLEASE !!!!

[flapokey]

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)

I want G2 to be blank when nothing is in the correct time in D48:K48.

What shows in G2 now is Blank the cell is blank, nothing no matter what
is entered in to D48:K48.

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

Can someone help me

flapokey

 

[flapokey]

Hello,

This amount that I am trying to move (to G2) is put in the cell
(D48:K48) automatically from another formula. Every hour I put othe
information in this table and several formulas are at work to give m
different figures. This is one of others working. So what I need i
when the appropiate cell is filled each hour than I need that total o
figure to move from the cell to another cell. But I need to new cell
information. I hope this helped. I did try to give the best exaple i
the post. The only thing is that there could be a hour where nothin
is put in the cell and that needs to be moved to G2. Yes a BLANK i
that is what is there. So I will try to give another example.

There are 8 cells for this to happen 1 for each hour

hour 1 the cell (D48) total is $200.00 well in cell G2 should rea
$200.00

hour 2 the cell (E48) total is (BLANK) NOTHING! well in cell G2 shoul
read ___ nothing!

hour 3 the cell (F48) total is $658.25 well in cell G2 should rea
$658.25

And so on for the rest of the cells. EVEN IF IT IS BLANK I NEED T
PROTRAY THAT IN G2.

Thanks flapokey :confused

 

[flapokey]

Hello,


Yes I did try the suggestion and it did work to a piont. It did no
move the blank cell
when it was blank to G2. Also I had to put in the hour.


Here is what I am trying to do. I need to know what the TOP sales ar
for the sales reps. On the Hour every hour.


I have EXAMPLE of EXCEL WORK SHEET. (THIS IS FOR AN 8 HOUR DAY)

SALES REP 1 HOUR1 HOUR2 HOUR3
HOUR 4 and so on for the rest of the hours to K (8 Hours)
I enter this amount manually D15 - $120.00
E15 - $200.00
F15 - $200.00 G15 - $200.00
D16 - $120.00 Formula =D15 E16 - $80.00 Formul
=IF(D15="","",E15-D15) F16 - (BLANK) Formul
=IF(E15="","",F15-E15) G16 - (BLANK) Formula =IF(F15="","",G15-F15)


SALES REP 2 HOUR 1 HOUR 2 HOUR 3

HOUR 4 and so on for the rest of the hours to K (8 Hours)
I enter this amount manually D27 - $250.00
E27 - $375.00
F27 - $625.00 G27 - $625.00
D28 - $250.00 Formula =D27 E28 - $125.00 Formul
=IF(D27="","",E27-D27) F28 - $250.00 Formul
=IF(E27="","",F27-E27) G28 - (BLANK) Formula =IF(F27="","",G27-F27)




SALES REP 3 HOUR 1 HOUR 2 HOUR 3

HOUR 4 and so on for the rest of the hours to K (8 Hours)
I enter this amount manually D39 - $90.00
E39 - $400.00
F39 - $845.00 G39 - $845.00
D40 - $90.00 Formula =D39 E40 - $310.00 Formul
=IF(D39="","",E39-D39) F40 - $445.00 Formul
=IF(E39="","",F39-E39) G40 - (BLANK) Formula =IF(F39="","",G39-F39)



Lets say that we only have the
1 hour at a time filled in filled in NO OTHERS HOURS ARE FILLED IN THE
ARE BLANK, except for past hours

D48 $250.00 Formula =MAX(D16,D28,D40)

For HOUR 1 G2 $250.00

NOW ON to HOUR 2
D48 $250.00 E48 $310.00

For HOUR 2 G2 $310.00

NOW ON to HOUR 3

D48 $250.00 E48 $310.00 F48 $845.00

For HOUR 3 G2 $845.00

NOW ON to HOUR 4 D48 $250.00 E48 $310.00 F48 $845.00 G48 (BLANK)

For HOUR 4 G2 (BLANK)


AND SO ON FOR THE THE OTHER HOURS ....................

flapokey :confused