Determining latest entry in Row of values and extracting value

[Andy McGooner]

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

 

[Bernie Deitrick]

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

 

[T. Valko]

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)

 

[Andy McGooner]

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












- Show quoted text -

Guys thanks,

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

 

[T. Valko]

You're welcome. Thanks for the feedback!