Extracting the latest info from 1st sheet and placing into a 2nd s

[tech1NJ]

I will like to extract the latest information from a given column in a sheet
(sheet1) and place it in another sheet (sheet 2) in B1. Here is my example of
data located in Sheet 1. I'm looking to extract specifically the latest build
number and place it in sheet 2, B1.

Date Time Error Message
6/24/2009 - 4:18 PM: Starting service
6/24/2009 - 4:18 PM: Starting initialization, build 1010
6/24/2009 - 4:18 PM: Connecting MS SQL db theserver, db testdata
6/24/2009 - 4:18 PM: Starting service
6/24/2009 - 4:18 PM: Starting initialization, build 1012
6/24/2009 - 4:18 PM: Connecting MS SQL db theserver, db testdata
6/24/2009 - 4:18 PM: Starting service
6/24/2009 - 4:18 PM: Starting initialization, build 1014
6/24/2009 - 4:18 PM: Connecting MS SQL db theserver, db testdata

tech1NJ

 

[Glenn]

I will like to extract the latest information from a given column in a sheet
(sheet1) and place it in another sheet (sheet 2) in B1. Here is my example of
data located in Sheet 1. I'm looking to extract specifically the latest build
number and place it in sheet 2, B1.

Date Time Error Message
6/24/2009 - 4:18 PM: Starting service
6/24/2009 - 4:18 PM: Starting initialization, build 1010
6/24/2009 - 4:18 PM: Connecting MS SQL db theserver, db testdata
6/24/2009 - 4:18 PM: Starting service
6/24/2009 - 4:18 PM: Starting initialization, build 1012
6/24/2009 - 4:18 PM: Connecting MS SQL db theserver, db testdata
6/24/2009 - 4:18 PM: Starting service
6/24/2009 - 4:18 PM: Starting initialization, build 1014
6/24/2009 - 4:18 PM: Connecting MS SQL db theserver, db testdata

tech1NJ

Assuming the Error Message is in C2:C10, try the following array formula (commit
with CTRL+SHIFT+ENTER):

=MAX(IF(ISERROR(FIND("build",C2:C10)),0,
--RIGHT(SUBSTITUTE(C2:C10," ",REPT(" ",10)),10)))