Prev: Excel "IF" functions
Next: changing a calculation in a pivot table
From: Glenn on 22 Feb 2010 15:19
tech1NJ wrote:
> 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)))
 | 
Pages: 1
Prev: Excel "IF" functions
Next: changing a calculation in a pivot table