Hi all, is there a way to have a blank cell when filtered return a blank cell instead of a Zero? It's really weird, wasn't expecting it as a result. I'm going to have to copy it to another location or else I'd use a conditional format. Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Blank Cells In Filter Results Showing As Zeros?
- Thread starter c.clavin
- Start date
jasonb75
Well-known Member
- Joined
- Dec 30, 2008
- Messages
- 15,507
- Office Version
- 365
- Platform
- Windows
I assume that you're using the filter formula rather than autofilter as that would show exactly what is in the original cell.
If you are using a filter formula then it would help if you post the formula that you are using so that we can edit it as an example rather than trying to explain in generic terms.
If you are using a filter formula then it would help if you post the formula that you are using so that we can edit it as an example rather than trying to explain in generic terms.
Upvote
0
Similar threads
- Solved
- Question
