Can anyone help? I need to find out if any of the times in the left three cells of a row are within some number (say ten seconds) of any of the times in the right three cells of the row then report in another column or highlight the two close cells.
I tried making an IF statement but couldnt work out how to compare any of the cells in the two ranges. Actually it could be to compare all cells in the row as I know the cells in each triplet will never match.
I tried making an IF statement but couldnt work out how to compare any of the cells in the two ranges. Actually it could be to compare all cells in the row as I know the cells in each triplet will never match.
Experiment index.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
AN | AO | AP | AQ | AR | AS | AT | |||
104 | 10:48:41 | 10:48:11 | 10:47:41 | 10:48:31 | 10:47:51 | 10:47:11 | |||
105 | 22:16:38 | 22:16:08 | 22:15:38 | 22:16:27 | 22:15:47 | 22:15:07 | |||
106 | 05:50:51 | 05:50:21 | 05:49:51 | 05:50:40 | 05:50:00 | 05:49:20 | |||
107 | 22:23:45 | 22:23:15 | 22:22:45 | 22:23:32 | 22:22:52 | 22:22:12 | |||
108 | 04:31:23 | 04:30:53 | 04:30:23 | 04:31:09 | 04:30:29 | 04:29:49 | |||
109 | 13:31:11 | 13:30:41 | 13:30:11 | 13:30:57 | 13:30:17 | 13:29:37 | |||
Sheet2 |