Determining latest entry in Row of values and extracting value

Andy McGooner

unread,

Jan 4, 2010, 11:16:32 AM1/4/10

to

Hi All,

I have a spreadsheet that monitors the performance of some
applications on a DVD across multiple versions prior to the final DVD
release. The problem is that the same application can be tested at any
point throughout the validation process and in some cases on more than
one DVD version i.e. V0, V1, V2, V3 etc and hence can pass or fail,
however i would like to be able to record the last known condition in
a column as i have to supply an overview off the overall status off
the DVD.

Therefore what i want to do is check a row of cells that cover the
validation results and place the final entry into the overall status
column for that application.

I apologise if this not worded very good, but if required a sample of
the spreadsheet can be made available.

Any help would be greatly appreciated.

Thanks in Advance,

Andy

@consumerdotorg Bernie Deitrick

unread,

Jan 4, 2010, 11:45:29 AM1/4/10

to

Andy,

Array enter (Enter using Ctrl-Shift-Enter) a formula like

=INDEX(A2:Z2,MAX(IF(A2:Z2<>"",COLUMN(A2:Z2))))

HTH,
Bernie
MS Excel MVP

"Andy McGooner" <andrew_...@yahoo.co.uk> wrote in message
news:afd4bf91-230f-4327...@t42g2000vba.googlegroups.com...

T. Valko

unread,

Jan 4, 2010, 12:28:34 PM1/4/10

to

This will return the rightmost *TEXT* entry from the referenced range:

=LOOKUP("zzzzzzzzzz",B1:Z1)

This will return the rightmost *NUMERIC* entry from the referenced range:

=LOOKUP(1E100,B1:Z1)

This will return the rightmost entry, text or numeric, from the referenced
range:

=LOOKUP(2,1/(B1:Z1<>""),B1:Z1)

--
Biff
Microsoft Excel MVP

"Andy McGooner" <andrew_...@yahoo.co.uk> wrote in message
news:afd4bf91-230f-4327...@t42g2000vba.googlegroups.com...

Andy McGooner

unread,

Jan 7, 2010, 9:07:04 AM1/7/10

to

On 4 Jan, 17:28, "T. Valko" <biffinp...@comcast.net> wrote:
> This will return the rightmost *TEXT* entry from the referenced range:
>
> =LOOKUP("zzzzzzzzzz",B1:Z1)
>
> This will return the rightmost *NUMERIC* entry from the referenced range:
>
> =LOOKUP(1E100,B1:Z1)
>
> This will return the rightmost entry, text or numeric, from the referenced
> range:
>
> =LOOKUP(2,1/(B1:Z1<>""),B1:Z1)
>
> --
> Biff
> Microsoft Excel MVP
>

> "Andy McGooner" <andrew_mcni...@yahoo.co.uk> wrote in message

>
> news:afd4bf91-230f-4327...@t42g2000vba.googlegroups.com...
>
>
>
> > Hi All,
>
> > I have a spreadsheet that monitors the performance of some
> > applications on a DVD across multiple versions prior to the final DVD
> > release. The problem is that the same application can be tested at any
> > point throughout the validation process and in some cases on more than
> > one DVD version i.e. V0, V1, V2, V3 etc and hence can pass or fail,
> > however i would like to be able to record the last known condition in
> > a column as i have to supply an overview off the overall status off
> > the DVD.
>
> > Therefore what i want to do is check a row of cells that cover the
> > validation results and place the final entry into the overall status
> > column for that application.
>
> > I apologise if this not worded very good, but if required a sample of
> > the spreadsheet can be made available.
>
> > Any help would be greatly appreciated.
>
> > Thanks in Advance,
>

> > Andy- Hide quoted text -
>
> - Show quoted text -

Guys thanks,

Much appreciated managed to utilise this to do what i wanted to do.

T. Valko

unread,

Jan 7, 2010, 1:08:58 PM1/7/10

to

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

"Andy McGooner" <andrew_...@yahoo.co.uk> wrote in message

news:acd267ac-53f6-4a3e...@z2g2000vbf.googlegroups.com...