I have table that has repeated timestamps (multiple records within 1 second). there are a variable number of records within each second; ranging from 1 record to 103 records within a second. I wish to develop a method to select only one random record from all the records with the same timestamp.
The Time column is column A. if possible, i would like the end result of the formula(s) (or macro/VBA) to have the word Keep in column B in the row that was randomly selected. all other non selected rows can be left blank.
thanks and i apologize if my example data table is not formatted correctly
[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]Time[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:10[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:10[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:11[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:11[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:11[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:11[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:11[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:11[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:12[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:12[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:13[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:13[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:13[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:13[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:13[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:13[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:14[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:14[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:15[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:15[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:15[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:15[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:15[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:15[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:16[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:16[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:17[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:17[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:17[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:17[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:17[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:17[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:18[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:18[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:19[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:19[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:19[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:19[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:19[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:19[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:20[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:20[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:21[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:21[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:21[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:21[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:21[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:21[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:22[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:22[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:22[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:22[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
</tbody>[/TABLE]
The Time column is column A. if possible, i would like the end result of the formula(s) (or macro/VBA) to have the word Keep in column B in the row that was randomly selected. all other non selected rows can be left blank.
thanks and i apologize if my example data table is not formatted correctly
[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]Time[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:05[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:06[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:07[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:08[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:09[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:10[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:10[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:11[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:11[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:11[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:11[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:11[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:11[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:12[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:12[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:13[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:13[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:13[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:13[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:13[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:13[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:14[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:14[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:15[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:15[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:15[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:15[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:15[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:15[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:16[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:16[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:17[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:17[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:17[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:17[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:17[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:17[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:18[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:18[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:19[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:19[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:19[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:19[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:19[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:19[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:20[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:20[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:21[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:21[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:21[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:21[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:21[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:21[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:22[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:22[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:22[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:22[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
[TR]
[TD="class: xl63"]7:51:23[/TD]
[/TR]
</tbody>[/TABLE]