View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tech1NJ tech1NJ is offline
external usenet poster
 
Posts: 58
Default Extracting the latest info from 1st sheet and placing into a 2nd s

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