LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default Selecting most recent data within several lines of data

I have multiple lines of data (in date order sequence, date has its own
column) that relate to multiple part number., i.e.,

part no a - data line 1
part no a - data line 2
part no a - data line 3
part no b - data line 1
part no b - data line 2 etc, etc...

I would like to know the easiest way to select the most recent line of data
for each unique part no. 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
Sort by data in most recent month Jenzz22 Excel Discussion (Misc queries) 2 January 24th 08 01:11 PM
Pivot charts - data disappear after selecting or data are static Patricia Maklari Excel Worksheet Functions 0 July 24th 07 01:36 PM
Recent ODBC problem linking to CSV data Safety in numbers Excel Discussion (Misc queries) 2 September 4th 06 05:05 PM
Pull recent pricing data from table Pierre Excel Worksheet Functions 8 August 1st 06 12:26 AM
Finding the most recent month's (or whatever) data Dallman Ross Excel Discussion (Misc queries) 10 July 1st 06 09:19 PM


All times are GMT +1. The time now is 02:12 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"