Advanced (?) Excel sorting
- by Preston Grayskull
First of all, I'd like to admit that I don't really know anything about Excel, but I have tried to look up a solution to this in Excel books and Googling.
Here's what I'm trying to do:
I have a really long spreadsheet There are 7 columns total, but only two columns that I'm most interested in. Here's an example CSV that is much more simple than my actual dataset, but the search/sort is analogous:
John, Apple
Dave, Apple
Dave, Orange
Steve, Apple
Steve, Orange
Steve, Kiwi
Bob, Apple
Bob, Banana
I'm interested in extracting the entire rows (all of the columns) that meet the following criteria:
["Apple"] OR ["Apple" and "Orange"] NOT ["Apple" and "Orange" and Anything Else] NOT ["Apple" and Anything that isn't Orange]
So with the above CSV, I would get the entire rows for John and Dave, but not Steve and not Bob.
I started doing this manually, and will likely finish by the time this question has an answer, but I would like to know this for future reference.
Thanks!
