excel select records based on multiple field values : how do I select records based on multiple field values in an excel table, eg, to answer the following question: "Identify all the transactions in which Jen sold lipstick in the East region". therefor I have to identify records where name=Jen product=lipstick and location=east.
TIA