Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi all
I wonder if you can help me, I've racked my brains, but cannot find a solution. I have a large table of data with e.g. the following headings Incident Number Date Incident Description Minutes 1 Minutes 2 Now in this table there are maybe 1500 records. Is there any way I can, in another spreadsheet in another workbook, create a table displaying, in descending order by Minutes 1, the top 5 Incidents? I thought about using LARGE and INDEX&MATCH on the minutes but it won't work because the minutes figure may not be unique. Many many many thanks in anticipation Danny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting number of incidents of a month | Excel Worksheet Functions | |||
filter errors depending on number of incidents | Excel Discussion (Misc queries) |