Hi Guys, I would need your help on the problem that I'm currently into... Basically I have the data below. I would like to extract the data having criteria: (# of data occurences under same Group >= 2 OR total dollar under same Group >= 25) , AND time range is less than 3 hours Please note: field "delta time" in "data wants" is row N - row N-1 on field "time" under same Group. For example: "delta time" = 5:51 in row 2 is coming from "time" in row 2 substracted by time in row 1. sample remarks: row 4 & 5 got remarks Yes because within 3 hrs (delta time for both rows is 1:43) and total "dollar" is 32 (16+18) or total count is 2 (count for row 4 & 5). row 9,10,11 got remarks Yes because within 3 hrs (sum delta time from 9-10 & 10-11 is 2 minutes, coming from 0:01+0:01) and total count is 3 (count for row 9,10,11). Thank you in advance Data Have : row Group dollar time 1 a 10 2:43 AM 2 a 10 8:34 AM 3 a 11 11:52 AM 4 b 16 5:32 AM 5 b 18 7:16 AM 6 b 12 2:08 PM 7 b 11 8:34 PM 8 b 13 9:31 PM 9 c 11 2:18 AM 10 c 5 2:19 AM 11 c 5 2:20 AM 12 c 12 8:34 AM 13 d 18 2:12 PM 14 e 19 2:43 AM 15 e 17 5:30 AM 16 e 11 12:07 PM 17 e 14 8:40 PM 18 e 16 8:46 PM 19 f 11 8:24 AM 20 f 12 11:55 AM Data Wants: row Group dollar time delta time Remarks 1 a 10 2:43 AM 2 a 10 8:34 AM 5:51 3 a 11 11:52 AM 3:18 4 b 16 5:32 AM Yes 5 b 18 7:16 AM 1:43 Yes 6 b 12 2:08 PM 6:51 7 b 11 8:34 PM 6:26 8 b 13 9:31 PM 0:57 9 c 11 2:18 AM Yes 10 c 5 2:19 AM 0:01 Yes 11 c 5 2:20 AM 0:01 Yes 12 c 12 8:34 AM 6:14 13 d 18 2:12 PM 5:38 14 e 19 2:43 AM Yes 15 e 17 5:30 AM 2:47 Yes 16 e 11 12:07 PM 6:37 17 e 14 8:40 PM 8:32 Yes 18 e 16 8:46 PM 0:05 Yes 19 f 11 8:24 AM 20 f 12 11:55 AM 3:31 Message was edited by: feira h --> to provide better explanation.
... View more