Hi everyone, I need help to solve this issue. At work we are reporting the top 3 breakdown events for each shift there are 3 shifts so would be 9 types of breakdowns all together. then on a 'summary' type page we report the top 3 of the 9 events.
to make it more difficult, each shifts report is on it's own sheet (Shift1, Shift2, Shift3) and the summary is on another (DMS).
the breakdown data is in the same range though a30:f32 on every sheet.
on the DMS sheet i have used a formula that will get me the top 3 from all of the sheets: =LARGE(Shift1:Shift3!$D$30:$D$32,1)
my result looks like this which is good.
my question is.... how do i get the data in the columns to the left and right of the minutes lost? I considered vlookup, but if there is duplicate times lost it won't work.
my office doesn't allow Xlookup or anything, so if i had to, i can move the minutes lost to column A to make it easier.
any thoughts?
to make it more difficult, each shifts report is on it's own sheet (Shift1, Shift2, Shift3) and the summary is on another (DMS).
the breakdown data is in the same range though a30:f32 on every sheet.
on the DMS sheet i have used a formula that will get me the top 3 from all of the sheets: =LARGE(Shift1:Shift3!$D$30:$D$32,1)
my result looks like this which is good.
Shift Report & DMS Dashboard v1.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
15 | TOP 3 DOWNTIME | |||||||
16 | LINE | ISSUE | MINUTES LOST | ROOT CASUE | ||||
17 | 10 | |||||||
18 | 9 | |||||||
19 | 9 | |||||||
DMS |
my question is.... how do i get the data in the columns to the left and right of the minutes lost? I considered vlookup, but if there is duplicate times lost it won't work.
my office doesn't allow Xlookup or anything, so if i had to, i can move the minutes lost to column A to make it easier.
any thoughts?