Loading...
Uploaded by ExcelIsFun on Sep 26, 2008
See how to Extract Records from one column that are not in another column using Advanced Filter and a TRUE FALSE COUNTIF function formula.
Science & Technology
Standard YouTube License
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
Load more suggestions
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