ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 733
- Office Version
- 2021
- 2019
- 2016
- 2010
- 2007
- Platform
- Windows
Hello - This may be me fundamentally not understanding something but I have tested this multiple times and I cant get to what I want. I really just want to unfilter any blank cells in row 21. Per the below should work, "i think."
but the problem i see if i have 0.00 in accounting format so "-", the above filter just filters off everything. blanks and "-". what am i doing wrong? is it because i have this formula in that column?
=IF(OR(B13=0,B13="",C13=1),"",(G13-O13))
VBA Code:
If Sheets("Compare").AutoFilterMode Then Sheets("Compare").AutoFilterMode = False
Sheets("Compare").Range("12:12").AutoFilter field:=21, Criteria1:="<>"
but the problem i see if i have 0.00 in accounting format so "-", the above filter just filters off everything. blanks and "-". what am i doing wrong? is it because i have this formula in that column?
=IF(OR(B13=0,B13="",C13=1),"",(G13-O13))