Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Two Instances | Excel Discussion (Misc queries) | |||
SUM all Instances Q | Excel Worksheet Functions | |||
3 Instances | Excel Discussion (Misc queries) | |||
Create list of unique instances from list of multiple Instances | Excel Worksheet Functions | |||
Is there an easy way to replace list A instances with list B instances (sorted lists). | Excel Programming |