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

  • Thread starter Thread starter tech1NJ
  • Start date Start date
T

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
 
tech1NJ said:
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
Click to expand...


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)))
 
Back
Top