Hello dear members,
I want to filter only the dates that are not the same as cell reference B10, but I want the hours to be ignored. In my case I want to keep only the dates 14.08.2022 and 16.08.2022 (hours ignored).
I have this macro but it doesn't do the job:
Sheets("Sheet1").Range("A2").AutoFilter Field:=2, Criteria1:="<>" & Cells(10, 2).Value
Maybe this could be useful? cell reference A1=LEFT(B10,10) ? Thus, it shows the date 15.08.2022
To change to:
Sheets("Sheet1").Range("A2").AutoFilter Field:=2, Criteria1:="<>" & Cells(1, 1).Value
Maybe some filter that "does not contain" cell reference B10 (hours to be ignored) ? Or that "does not contain" cell reference A1 ?
Please, would anybody be willing to help me ?
I want to filter only the dates that are not the same as cell reference B10, but I want the hours to be ignored. In my case I want to keep only the dates 14.08.2022 and 16.08.2022 (hours ignored).
I have this macro but it doesn't do the job:
Sheets("Sheet1").Range("A2").AutoFilter Field:=2, Criteria1:="<>" & Cells(10, 2).Value
Maybe this could be useful? cell reference A1=LEFT(B10,10) ? Thus, it shows the date 15.08.2022
To change to:
Sheets("Sheet1").Range("A2").AutoFilter Field:=2, Criteria1:="<>" & Cells(1, 1).Value
Maybe some filter that "does not contain" cell reference B10 (hours to be ignored) ? Or that "does not contain" cell reference A1 ?
Please, would anybody be willing to help me ?
Tickets.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | 15.08.2022 | TICKETS | ||
2 | COUNTRY | DATE | ||
3 | ARGENTINA | 14.08.2022 11:30 | ||
4 | AUSTRALIA | 14.08.2022 14:45 | ||
5 | BELGIUM | 14.08.2022 18:00 | ||
6 | BRAZIL | 15.08.2022 11:30 | ||
7 | CANADA | 15.08.2022 12:45 | ||
8 | CHILE | 15.08.2022 14:00 | ||
9 | COLOMBIA | 15.08.2022 15:30 | ||
10 | COSTA RICA | 15.08.2022 16:15 | ||
11 | DENMARK | 15.08.2022 17:00 | ||
12 | ECUADOR | 15.08.2022 17:45 | ||
13 | FINLAND | 15.08.2022 18:30 | ||
14 | FRANCE | 15.08.2022 19:00 | ||
15 | GERMANY | 15.08.2022 20:15 | ||
16 | GREECE | 15.08.2022 21:00 | ||
17 | ICELAND | 15.08.2022 22:30 | ||
18 | ITALY | 15.08.2022 23:45 | ||
19 | JAPAN | 16.08.2022 15:30 | ||
20 | USA | 16.08.2022 19:00 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A1 | A1 | =LEFT(B10,10) |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A3:A20 | Cell Value | contains "Stage" | text | NO |
A3:A20 | Cell Value | contains "Losers" | text | NO |
A3:A20 | Cell Value | contains "Winners" | text | NO |
A3:A20 | Cell Value | contains "Promotion" | text | NO |
A3:A20 | Cell Value | contains "Promotion Group" | text | NO |
A3:A20 | Cell Value | contains "Taca" | text | NO |
A3:A20 | Cell Value | contains "Play Offs" | text | NO |
A3:A20 | Cell Value | contains "Play Off" | text | NO |
A3:A20 | Cell Value | contains "Women" | text | NO |
A3:A20 | Cell Value | contains "WORLD" | text | NO |
A3:A20 | Cell Value | contains "EUROPE" | text | NO |
A3:A20 | Cell Value | contains "EURO" | text | NO |
A3:A20 | Cell Value | contains "UEFA" | text | NO |
A3:A20 | Cell Value | contains "CONCACAF" | text | NO |
A3:A20 | Cell Value | contains "Europa League" | text | NO |
A3:A20 | Cell Value | contains "Champions League" | text | NO |
A3:A20 | Cell Value | contains "Friendly" | text | NO |
A3:A20 | Cell Value | contains "Trophy" | text | NO |
A3:A20 | Cell Value | contains "Taça" | text | NO |
A3:A20 | Cell Value | contains "Pokal" | text | NO |
A3:A20 | Cell Value | contains "Beker" | text | NO |
A3:A20 | Cell Value | contains "Coppa" | text | NO |
A3:A20 | Cell Value | contains "Coupe" | text | NO |
A3:A20 | Cell Value | contains "Copa" | text | NO |
A3:A20 | Cell Value | contains "Cup" | text | NO |
A3:A20 | Cell Value | contains "Relegation" | text | NO |
A3:A20 | Cell Value | contains "Championship Group" | text | NO |
A3:A20 | Cell Value | contains "Relegation Group" | text | NO |