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

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
cssc1Asked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
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
 
cssc1Author Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.