Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting the latest info from 1st sheet and placing into a2nd s
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))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How retreive specific data from 1st Sheet and placing it on 2nd Sh | Excel Discussion (Misc queries) | |||
Extracting info to new tables | Excel Discussion (Misc queries) | |||
placing a button directly in a sheet | Excel Discussion (Misc queries) | |||
help with placing Logo on excel sheet | Excel Discussion (Misc queries) | |||
Option Buttons move after placing on sheet | Excel Worksheet Functions |