Find latest value in a series.
 

Hi
I have 4 rows of data.
Row 1 = Months of the year, Jan, Feb etc
Row 2 = target Values
Row 3 Actual Values
Row 4 Amber Values (vary between 80-90% of target)

I am creating a graph on separate tab and as a summary would like to bring
back the latest value on each row.
So if i complete for July, the summary will show me Target Actual and Amber
in 3 diff cells next to graph for July. If i plug in Aug data, the summary
changes to that data.

I have had a play with various methids, but cant cracki t.
Hopefully i have explained ok for all,
Can anyone help?
Many Thanks
Matt

--
Matt Lynn

Message posted via http://www.officekb.com

Find latest value in a series.
 

=LOOKUP(1E100,1:1)


"Mattlynn via OfficeKB.com" wrote:

Hi
I have 4 rows of data.
Row 1 = Months of the year, Jan, Feb etc
Row 2 = target Values
Row 3 Actual Values
Row 4 Amber Values (vary between 80-90% of target)

I am creating a graph on separate tab and as a summary would like to bring
back the latest value on each row.
So if i complete for July, the summary will show me Target Actual and Amber
in 3 diff cells next to graph for July. If i plug in Aug data, the summary
changes to that data.

I have had a play with various methids, but cant cracki t.
Hopefully i have explained ok for all,
Can anyone help?
Many Thanks
Matt

--
Matt Lynn

Message posted via http://www.officekb.com

Find latest value in a series.
 

Hi teethless - sorry but i do not understand the formula suggestion you have
given?
Thanks

Can you please explain?


Teethless mama wrote:
=LOOKUP(1E100,1:1)

Hi
I have 4 rows of data.
[quoted text clipped - 14 lines]
Many Thanks
Matt

--
Matt Lynn

Message posted via http://www.officekb.com

Find latest value in a series.
 

TM's formula will return the last (rightmost) numeric value from row 1.

If that's what you wanted then just change the range reference to suit your
application. For example:

=LOOKUP(1E100,Sheet1!D5:J5)

--
Biff
Microsoft Excel MVP


"Mattlynn via OfficeKB.com" <u44078@uwe wrote in message
news:9d495ae23d4d3@uwe...
Hi teethless - sorry but i do not understand the formula suggestion you
have
given?
Thanks

Can you please explain?


Teethless mama wrote:
=LOOKUP(1E100,1:1)

Hi
I have 4 rows of data.
[quoted text clipped - 14 lines]
Many Thanks
Matt

--
Matt Lynn

Message posted via http://www.officekb.com

Find latest value in a series.
 

Thats brillaint - Thanks T Valko and thanks teethless mama

T. Valko wrote:
TM's formula will return the last (rightmost) numeric value from row 1.

If that's what you wanted then just change the range reference to suit your
application. For example:

=LOOKUP(1E100,Sheet1!D5:J5)

Hi teethless - sorry but i do not understand the formula suggestion you
have
[quoted text clipped - 10 lines]
Many Thanks
Matt

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200910/1

Find latest value in a series.
 

thanks teethless mama - thats an outstanding formula - thanks again!

Teethless mama wrote:
=LOOKUP(1E100,1:1)

Hi
I have 4 rows of data.
[quoted text clipped - 14 lines]
Many Thanks
Matt

--
Matt Lynn

Message posted via http://www.officekb.com

Find latest value in a series.
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Mattlynn via OfficeKB.com" <u44078@uwe wrote in message
news:9d52e15de0010@uwe...
Thats brillaint - Thanks T Valko and thanks teethless mama

T. Valko wrote:
TM's formula will return the last (rightmost) numeric value from row 1.

If that's what you wanted then just change the range reference to suit
your
application. For example:

=LOOKUP(1E100,Sheet1!D5:J5)

Hi teethless - sorry but i do not understand the formula suggestion you
have
[quoted text clipped - 10 lines]
Many Thanks
Matt

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200910/1