Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel Magic Trick #105: Extract Records Trick

Loading...

Sign in or sign up now!
6,284
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by 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.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (2)

Sign In or Sign Up now to post a comment!
  • 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.

  • How come you have to copy the blank above the false in B8 and C8?

Loading...

0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more