ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 793
- Office Version
- 365
- 2019
- Platform
- Windows
Hi, I have two scenarios where I am trying to solution and cant seem to get the results I was expecting
Trying to filter data based on a field not equaling 2 but the data is in text on my excel data and also filtering out a date based off a cell value
D5 =TEXT(TODAY(),"YYYYMMDD")
Today is 07/11/20 for reference
Range("10:10").AutoFilter Field:=5, Criteria1:="<>AB"
Range("10:10").AutoFilter Field:=3, Criteria1:="<>2"
Range("10:10").AutoFilter Field:=4, Criteria1:="<>Range(D5)"
Trying to filter data based on a field not equaling 2 but the data is in text on my excel data and also filtering out a date based off a cell value
D5 =TEXT(TODAY(),"YYYYMMDD")
Today is 07/11/20 for reference
Range("10:10").AutoFilter Field:=5, Criteria1:="<>AB"
Range("10:10").AutoFilter Field:=3, Criteria1:="<>2"
Range("10:10").AutoFilter Field:=4, Criteria1:="<>Range(D5)"
Date | Date | # | Date | View Indicator |
20200710 | 20200710 | 0 | 0 | AB |
20200712 | 20200712 | 1 | 20200712 | AA |
20200712 | 20200712 | 2 | 20200712 | AC |
20200712 | 20200712 | 0 | 0 | AD |