FILTER logic: Minus

- [Narrator] Filtering two criteria with a Minus Sign. … That means we want one or the other, … not both. … Here I've got a list of addresses. … I am interested in those that have a massive lawn, … or a swimming pool, not both. … Both would be too much maintenance. … I don't want 3672 Pearcy Avenue. … It has neither a pool or a massive lawn. … I do want 1026 38th Avenue because it does have a pool. … But I do not want 3903 Adams Drive, Southeast. … Massive lawn. … Yes. A swimming pool. … Too much work. … My Saturdays are gone. … Let's filter and get those addresses. … Equals. … Filter. … What do we want to filter? … Where's our array? … That's this entire table. … I'm going to go here and wait for the arrow to come up. … And it's picked Table One. … Comma. … What do we want to include? … This is where we put our two criteria. … Our first criteria. Open Parentheses. … Let's filter for the lawn. … Like lawn. … Equals. … that sale. Massive. … Close Parentheses. … Minus. … Open Parentheses. …