View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Opal Opal is offline
external usenet poster
 
Posts: 59
Default MS Query + last 5 instances

I am trying to run an MS Query in Excel to give me the
last 5 instances in date order, descending on
an excel spreadsheet with the following headings:

DTDate / Line / PartNo / DTMin / Reason

(DTMin = Downtime in minutes)

I need to pull from a spreadsheet in excel that has over
8000 records (and growing) the 5 most recent downtime
instances for each and every part number. I cannot use
a date range as some parts can run 5 times in 2 weeks and
some can take 2 months. I have been working with various
ideas but cannot get the language quite right. Can anyone
point me in the right direction? Thank you!