Goldenrules
New Member
- Joined
- Jul 16, 2022
- Messages
- 25
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
- Mobile
- Web
In a workbook I have two sheet "Sheet 1" and "sheet 2". On *sheet 1" is the data I got from a website,
The table is header Starts from A2:C23
ID DATE TIME
430019827 Apr 202410:00:54 AM
430019927 Apr 202410:01:44 AM
430020027 Apr 202410:02:34 AM
430020127 Apr 202410:03:24 AM
430021027 Apr 202410:10:54 AM
430021127 Apr 202410:11:44 AM
430021227 Apr 202410:12:34 AM
430021327 Apr 202410:13:24 AM
430021427 Apr 202410:14:14 AM
430021527 Apr 202410:15:04 AM
430021627 Apr 202410:15:54 AM
430021727 Apr 202410:16:44 AM
430021827 Apr 202410:17:34 AM
430021927 Apr 202410:18:24 AM
430022027 Apr 202410:19:14 AM
430022127 Apr 202410:20:04 AM
430022227 Apr 202410:20:54 AM
430022327 Apr 202410:21:44 AM
430022427 Apr 202410:22:34 AM
430022527 Apr 202410:23:24 AM
430022627 Apr 202410:24:14 AM
Now because this data are gotten from web scraping a website, I do have some omissions, so the main essence for the sheet 2 is to validate the captured data time and to know the omitted ones.
Here is the file for better understanding
The table is header Starts from A2:C23
ID DATE TIME
430019827 Apr 202410:00:54 AM
430019927 Apr 202410:01:44 AM
430020027 Apr 202410:02:34 AM
430020127 Apr 202410:03:24 AM
430021027 Apr 202410:10:54 AM
430021127 Apr 202410:11:44 AM
430021227 Apr 202410:12:34 AM
430021327 Apr 202410:13:24 AM
430021427 Apr 202410:14:14 AM
430021527 Apr 202410:15:04 AM
430021627 Apr 202410:15:54 AM
430021727 Apr 202410:16:44 AM
430021827 Apr 202410:17:34 AM
430021927 Apr 202410:18:24 AM
430022027 Apr 202410:19:14 AM
430022127 Apr 202410:20:04 AM
430022227 Apr 202410:20:54 AM
430022327 Apr 202410:21:44 AM
430022427 Apr 202410:22:34 AM
430022527 Apr 202410:23:24 AM
430022627 Apr 202410:24:14 AM
Now because this data are gotten from web scraping a website, I do have some omissions, so the main essence for the sheet 2 is to validate the captured data time and to know the omitted ones.
Here is the file for better understanding
Balls Tracker - (49) testing formula
Sheet1 ,,,,,,,, ID,DATE,TIME,DRAWS,Range,Total,Win Colour,,Colours 4300198,27 Apr 2024,10:00:54 AM,13,8,16,7,36,38,L,118,RED,,3,1,2 4300199,27 Apr 2024,10:01:44 AM,28,26,9,25,1,46,L,135,RED,,4,1,1 4300200,27 Apr 2024,10:02:34 AM,8,24,37,14,7,15,L,105,None,,2,2,2 4300201,27 Apr 2024,10:03:24 AM,2...
docs.google.com