abarbee314
New Member
- Joined
- Apr 5, 2013
- Messages
- 24
Hi folks! Hope you're all doing well. I'll paste a sample data set down below, but here is the scenario for it:
Real/larger data set has nearly 2000 rows and 20+ columns. Many of the names appear in 2+ rows for some reason. SOME of the rows have a value in the second column that voids their need to be in the table. We want ALL entries for the names to be removed if *ANY* of them have the voiding value.
So, below I have decided that SNARKY is the "bad" word. My need here: If SNARKY appears as the status for someone, I want all rows for that person to selectable/deletable/deleted - whatever is the cleanest or most efficient.
Based on my sample sheet, the end result should only have rows for Sally, Mary, Carmen, and Kaitlin. Shawn and I are SNARKY, so all of our rows need to be removed since at least one of them has SNARKY as the status. Hope that makes sense. THANKS, in advance, as always
Real/larger data set has nearly 2000 rows and 20+ columns. Many of the names appear in 2+ rows for some reason. SOME of the rows have a value in the second column that voids their need to be in the table. We want ALL entries for the names to be removed if *ANY* of them have the voiding value.
So, below I have decided that SNARKY is the "bad" word. My need here: If SNARKY appears as the status for someone, I want all rows for that person to selectable/deletable/deleted - whatever is the cleanest or most efficient.
Based on my sample sheet, the end result should only have rows for Sally, Mary, Carmen, and Kaitlin. Shawn and I are SNARKY, so all of our rows need to be removed since at least one of them has SNARKY as the status. Hope that makes sense. THANKS, in advance, as always

Name | Status | State |
Aaron | Right-handed | Florida |
Aaron | Snarky | Florida |
Aaron | Brunette | Florida |
Sally | Blonde | New York |
Shawn | Brunette | Hawaii |
Shawn | Snarky | Hawaii |
Mary | Brunette | Kansas |
Carmen | Right-handed | Missouri |
Kaitlin | Blonde | Illinois |
Kaitlin | Right-handed | Illinois |