How come you have to copy the blank above the false in B8 and C8?
focusonjeff 1 year ago
When you use a TRUE / FALSE formula for Advanced Filter, it is programmed to expect a blank cell above the formula. If you don't do it that way, it won't work. Just the way Microsoft programmed it.
ExcelIsFun 1 year ago
How come you have to copy the blank above the false in B8 and C8?
focusonjeff 1 year ago
When you use a TRUE / FALSE formula for Advanced Filter, it is programmed to expect a blank cell above the formula. If you don't do it that way, it won't work. Just the way Microsoft programmed it.
ExcelIsFun 1 year ago