Using filter you can extract data based on.
Answers
Answered by
16
Answer:Create a Unique list of items.
Add a drop-down filter to display these unique items.
Use helper columns to extract the records for the selected item.
Answered by
17
Explanation:
The data filtering in a spreadsheet is to set criteria which enable to display only certain data to the user. This helps to focus on certain details in a huge dataset or table of data.
The filtering does not change or delete the data in the worksheet. This filtering just displays the rows or columns to appear in the active Excel worksheet. The filters enable to limit of viewing data in the worksheet by hiding the relevant portion of it from the user.
Similar questions
Geography,
6 months ago
CBSE BOARD X,
11 months ago