![]() Create a table with the selected conditions.The user easily finds the unique values in a multi-line array with the help of the advanced filter.Ī ready-made example is how to use the advanced filter in Excel:.The criteria for selecting the data are visible.You can set as many conditions for filtering as you want.But each previous result can hide the records necessary for the next filter.Īn extended filter has many more features: It is acceptable to apply several filtering conditions at once.The tool treats the top line as column headers and these values are not included in the filter.Different tables on one sheet cannot be filtered, even if they have the same type of data. AutoFilter works only in an unbroken range.We put the tick in front of the corresponding filtering condition: ![]() For example, display the supplies to the store number. To use the auto-filter is a simple thing: you just need to select an entry with the desired value. If you format the data range as a table or declare it as a list, the auto filter will be added immediately.
0 Comments
Leave a Reply. |