database - Excel automatic show the list table of raw data information if it match 1 condition - Stack Overflow

admin管理员组

文章数量:1291043

A detail of data include 5 group of ID : a, b, c, d, e

I want to create 5 sheets of a, b, c, d, e If 19 lines have ID a then 19 line of all information in the raw sheet is shown on [sheet a] 13 lines have ID b then 13 line of all information in the raw sheet is shown on [sheet b] 11 lines have ID c then 11 line of all information in the raw sheet is shown on [sheet c] 20 lines have ID d then 20 line of all information in the raw sheet is shown on [sheet d] ...

functions and formula to get the list information match with my condition

A detail of data include 5 group of ID : a, b, c, d, e

I want to create 5 sheets of a, b, c, d, e If 19 lines have ID a then 19 line of all information in the raw sheet is shown on [sheet a] 13 lines have ID b then 13 line of all information in the raw sheet is shown on [sheet b] 11 lines have ID c then 11 line of all information in the raw sheet is shown on [sheet c] 20 lines have ID d then 20 line of all information in the raw sheet is shown on [sheet d] ...

functions and formula to get the list information match with my condition

• excel
• database
• excel-formula

Share Improve this question Follow asked Feb 20 at 10:35 Hoàng Trinh VũHoàng Trinh Vũ 1111 bronze badge 2

• 3 You should look into FILTER(), it will probably look something like: `=FILTER(data rng,ID rng = "a"). – Excellor Commented Feb 20 at 10:40
• If you don't have FILTER, you might look into AGGREGATE. – Evil Blue Monkey Commented Feb 20 at 15:14

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 1

=FILTER(B4:C26,--(B4:B26="a"))

• requires Office 365 compatible v. Excel
• customize as req. (replace 'a' with desired ID/update reference b4:b26 with 'raw data' location etc.)

---

You might also look at putting the data into a pivot table and using the "Show report filter pages" function. Here is a tutorial if you are interested: Create Multiple Pivot Table Reports with Show Report Filter Pages

本文标签： databaseExcel automatic show the list table of raw data information if it match 1 conditionStack Overflow