Only display the last entry in a range

[Bobefax]

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

 

[Aladin Akyurek]

On 2002-03-01 06:44, Drew wrote:
Aladin,
Would the idex/match function work just as well? Just wondering.

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

Drew

Drew,

You're darn right. I wonder why I forget my own tricks. Thanks for the reminder.

Allow me to slightly modify it:

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

Bobefax: Forget that expensive formula and use this instead.

Aladin

 

[Bobefax]

Drew/Aladin.

MANY MANY THANKS.

The Last thing was just what it needed.

Thanks again......

Bobefax