LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Run data analysis

I don't know if this is possible or not:

I import data from a manufacturing process.
Column A - Date
Column B - Product Name

I want to have a table that displays the date (column A) when Product Name
(Column B) changes.

Data Example
11/01/08 8:00am 23LIN
11/01/08 8:30am 23LIN
11/01/08 9:00am 23LIN
11/01/08 9:30am 33LIN
11/01/08 10:00am 33LIN
11/01/08 10:30am 33LIN

What I'm looking for is the automatic calculation of a table that would say
11/01/08 8:00am 23lin
11/01/08 9:30am 33lin

I've tried everything that I can think of and haven't come up with anything
that's fully automated. Am I asking the impossible?

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Analysis Plus Niyanta Charts and Charting in Excel 6 April 24th 06 07:03 PM
Why " data analysis plus " override " data analysis " once instal. Alfred H K Yip Excel Worksheet Functions 1 March 20th 05 08:10 AM
Analysis ToolPak installed but no Data Analysis option Eric Stephens Excel Discussion (Misc queries) 3 February 2nd 05 09:17 PM


All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"