TUTORIAL UPDATES | Displaying Data Groups with 2 Criteria | No Filters

Previously, thank you for visiting this channel
This video explains how to display data groups with 2 criteria in Microsoft Excel
Notes:
Data Group Formula:
=IFERROR(INDEX(DATABASE,SMALL(IF(CRITERIA=$I$1,ROW(CRITERIA)),ROW(B1)),2),"")
Use CSE to end
Don't Forget to Check Other Other Tutorials:
- How to Make an Expired Excel File - Expired
• Tutorial Excel | Cara ...
- Create Multilevel Dropdown List Menu | IF & INDIRECT functions
• Tutorial Excel | Membu...
- Easily Create a Login Form on an Excel Worksheet
• Tutorial | Mudahnya Me...
- 30 Frequently Used Excel Formulas:
• Excel Pemula | 30 Rumu...
- Create a Multiple Choice Correction App
• Tutorial Membuat Aplik...
- Display excel rows and columns according to cell contents:
• Tutorial | Menyembunyi...
- Create a website mode excel menu:
• Tutorial | Cara Membua...
- Create a fullscreen excel view:
• Tutorial | Cara Membua...
tags:
#tutor_assaif
#show_group_data
#most_easy_filter_data
#formula_excel
#group_data_2_criteria