Hi Guys, I have file that looks like this below (20 x 4) matrix. It consists of time, serial number, pessure and volume. I want to select the maximum value of pressure and the corresponding volume and time for each serial numbers every 4 secs all through the data. There are 4 items, serial number 1 represents the first, 2 the second, e.t.c. However the serial number 1 represents time where there is low/ no pressure as well. Could you help with this? Thanks
Time S/N Pressure Volume00:00:01 1 20 2.400:00:02 1 25 2.500:00:03 1 30 2.600:00:04 1 35 2.700:00:05 1 0.3 2.800:00:06 1 1.4 2.900:00:07 2 20 300:00:08 2 30 3.100:00:09 2 40 3.200:00:10 2 50 3.300:00:11 1 0.6 3.400:00:12 1 1.5 3.500:00:13 3 20 3.600:00:14 3 30 3.700:00:15 3 40 3.800:00:16 3 50 3.900:00:17 1 0.1 400:00:18 1 2.3 4.100:00:19 4 20 4.200:00:20 4 30 4.300:00:21 4 34 4.400:00:22 4 50 4.500:00:23 1 0.3 4.600:00:24 1 4.1 4.7
Best Answer