Solved

How do I make a formula to extract data based on criteria?

Posted on 2014-09-04
2
173 Views
Last Modified: 2014-09-04
I have several criteria to use for selecting specific data from a table. The criteria is attached to the sample spreadsheet attached. I can extract one criteria, but, when I try to put them together I get errors.

any help is appreciated
SAMPLE-Spreadsheet.xlsx
0
Comment
Question by:cssc1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 51

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40303375
You could use the Advanced Filter

see example

or with a helper's column

the Auto Filter

=IF(AND(B6=$F$1,E6>=$C$1,E6<=$C$2,LEFT(C6,2)="NM"),True,False)

see example as well

Regards
SAMPLE-SpreadsheetV1.xlsx
0
 

Author Closing Comment

by:cssc1
ID: 40303678
Thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question