Prev: Counting Values in a list
Next: Office Project vs. Office Web Component
From: tech1NJ on 22 Feb 2010 10:28
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
 | 
Pages: 1
Prev: Counting Values in a list
Next: Office Project vs. Office Web Component