O
Opal
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!
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!