Hi,
I have data as under in a sheet. I want to capture data for any value which exceed 5 in cells ( B16:J16) and the corresponding devices in cells (B1:J1) for that value. The values in cells B16 to J16 keeps on changing daily.
The expected results which are updated daily are shared below the table.
<tbody>
</tbody>
Thanks,
Vijay
I have data as under in a sheet. I want to capture data for any value which exceed 5 in cells ( B16:J16) and the corresponding devices in cells (B1:J1) for that value. The values in cells B16 to J16 keeps on changing daily.
The expected results which are updated daily are shared below the table.
Noida | 802-1-01 NOI:FLR1 TURN3 IN | 802-1-17 NOI:FIRE ALARM | 802-1-26 NOI:FLR3 FIRE STR 1 | 802-1-27 NOI:FLR4 FIRE STR 1 | 802-1-33 NOI:FLR5 FIRE STR 1 | 802-2-00 NOI:SERVICE ELEV | 802-3-00 NOI:CAFE SIDE DOOR | 802-3-01 NOI:FLR1 TURN3 OUT | 802-4-00 NOI:SHIPPING REAR DR |
19-Jul-13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 75 | 0 |
20-Jul-13 | 10 | 1 | 1 | 1 | 80 | 1 | 1 | 1 | 1 |
21-Jul-13 | 20 | 2 | 5 | 2 | 2 | 2 | 2 | 2 | 22 |
22-Jul-13 | 5 | 3 | 3 | 3 | 7 | 3 | 3 | 3 | 3 |
23-Jul-13 | 6 | 4 | 4 | 4 | 4 | 22 | 44 | 4 | 4 |
24-Jul-13 | 7 | 5 | 7 | 5 | 5 | 5 | 25 | 5 | 5 |
25-Jul-13 | 9 | 6 | 6 | 6 | 9 | 6 | 6 | 6 | 6 |
26-Jul-13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
27-Jul-13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
28-Jul-13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
29-Jul-13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
30-Jul-13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
31-Jul-13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Total | 57 | 21 | 26 | 21 | 107 | 39 | 81 | 96 | 41 |
Average | 4 | 2 | 2 | 2 | 8 | 3 | 6 | 7 | 3 |
Expected result | |||||||||
Location | Device Name | No of Alarms | |||||||
Noida | 802-1-33 NOI:FLR5 FIRE STR 1 | 8 | |||||||
802-3-00 NOI:CAFE SIDE DOOR | 6 | ||||||||
802-3-01 NOI:FLR1 TURN3 OUT | 7 |
<tbody>
</tbody>
Thanks,
Vijay