Solved

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

Posted on 2014-09-04
2
158 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
2 Comments
 
LVL 48

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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

757 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now