Hello, I have a list of data that is roughly over 1000 rows and 10 columns although I only really need the first three columns. Below is an example of the data, at first I was looking to just use a vlookup based on "today's" date but the data extraction is not consistent. I only want to return the first three columns based on "today's" date. Any help or advice is greatly appreciated, I am trying to avoid a bunch of manual manipulation of the data if possible.
A | B | C | D | E | F | G | H | I | J | |
1 | 11/26/2020 14:00 | Smith John | smithj@hotmail.com | 7057178888 | Blank | CB | Service Location | Address | 5 | One on One |
2 | 11/26/2020 14:05 | Smith John | jsmith@gmail.com | 4162222222 | Blank | CB | Service Location | Address | 5 | One on One |
3 | 11/26/2020 14:10 | Smith John | xxxx@outlook.ca | 5554446666 | Blank | CB | Service Location | Address | 5 | One on One |
4 | 11/27/2020 9:00 AM | Smith John | 1234@xyz.ca | 7057899999 | Blank | CB | Service Location | Address | 5 | One on One |
5 | 11/27/2020 2:00 PM | Smith Jane | smithj@outlook.ca | 5551238888 | Blank | CB | Service Location | Address | 5 | One on One |
6 | 11/27/2020 2:00 PM | Last First Name | 1234@hotmail.com | 5554567777 | Blank | CB | Service Location | Address | 5 | One on One |
7 | 11/28/2020 11:00 | doe Jane | 456@hotmail.com | 5554568888 | Blank | CB | Service Location | Address | 5 | One on One |
8 | 11/28/2020 14:00 | doe john | 123@gmail.com | 5554568888 | Blank | CB | Service Location | Address | 5 | One on One |
9 | 11/28/2020 14:05 | doe jj | 789@xxx.com | 5554568888 | Blank | CB | Service Location | Address | 5 | One on One |
10 | 11/28/2020 2:10 PM | smith h | xxxx@hotmail.com | 5557891111 | Blank | CB | Service Location | Address | 5 | One on One |