Only display the last entry in a range

Bobefax

New Member
Joined
Feb 28, 2002
Messages
9
I have a row of data B3:G3 and a summary cell H3.

Cell B3 C3 D3 E3 F3 G3
Value 12

in H3 this would display 12

If I then entered 14 in D3 it would then show 14 in H3.

Any suggestions?

Thanks
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
On 2002-03-01 04:04, Ian Mac wrote:
What about:

=MAX(B3:G3)

Ian,

Not sure but it seems Bobefax wants in H3 the value of the cell changed most recently in the range B3:G3. That would require VBA, I think.

Aladin
 
Upvote 0
Sorry,

I should have been clearer your suggestion only shows the highest value.

I need to show any value that is typed after B3 regardless of value, so I am looking to change the value of H3 everytime a subsequnat entry is made in the ros B3:H3.

Thanks anyway.
 
Upvote 0
Ian/Aladin,

Don't think I need VBA (hope not anyways!)

It sounds simple, just to change the value in H3 to match a value in range B3:G3, the values of range B3:G3 will be entered over a period of time (weekly), each Column B-G is a time period, so once entered they will not be changed.

At the end of the period G3 this will be the value in H3, but say after 3 weeks the value of D3 would need to be displayed 8 in H3.

Hope this clears it a bit more!.

Thanks
This message was edited by Bobefax on 2002-03-01 04:46
 
Upvote 0
On 2002-03-01 04:45, Bobefax wrote:
Ian/Aladin,

Don't think I need VBA (hope not anyways!)

It sounds simple, just to change the value in H3 to match a value in range B3:G3, the values of range B3:G3 will be entered over a period of time (weekly), each Column B-G is a time period, so once entered they will not be changed.

At the end of the period G3 this will be the value in H3, but say after 3 weeks the value of D3 would need to be displayed 8 in H3.

Hope this clears it a bit more!.

Thanks
This message was edited by Bobefax on 2002-03-01 04:46

If you have something like:

Week 1, a value is entered in B3, say 8, C3:G3 is empty as yet;

Week 2, a value is entered in C3, say 5, D3:G3 is empty as yet;

etc., then

H3 will have the value of B3 in Week 1, that is, 8;

H3 will have the value of B3 in Week 2, that is, 5;

etc.

Then that's doable with a formula in H3, but I'm not yet convinced that this is the case.

Any comments?

Aladin
 
Upvote 0
On 2002-03-01 06:02, Bobefax wrote:
Aladin,

What you have described id EXACTLY what I want.

HELP..........

Bobefax

In H3 array-enter:

=INDEX(3:3,SUM((MAX((LEN(B3:G3)>0)*COLUMN(B3:G3)))))

To array-enter a formula you need to hit control+shift+enter, not just enter.

Aladin
This message was edited by Aladin Akyurek on 2002-03-01 06:32
 
Upvote 0
Aladin,
Would the idex/match function work just as well? Just wondering.

=INDEX(B3:G3,MATCH 9.99999999999999E+307,B3:G3))

Drew
 
Upvote 0
Drew,

Having a problem with your suggestion.

=INDEX(B3:G3,MATCH 9.99999999999999E+307,B3:G3))

Seems it may not have pasted across OK.

Only one open bracket but two close !!

bobefax
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top