Many employees of various organizations who have to work with Mircosot Excel in any way, whether they are ordinary accountants or analysts, often face the need to select a number of values from a huge data array. To simplify this task, a filtering system was created.
Normal and advanced filter
Excel presents the simplest filter, which is launched from the “Data” - “Filter” tab (Data - Filter in the English version of the program) or by using a shortcut on the toolbar that looks like a cone-shaped funnel for pouring liquid in a bottle with a narrow neck.
. , ( , ), , Excel. Advanced filter.
Excel . -, , -, (). , , Excel. : , . , .
Excel, , .
| A | B | C | D | E | F |
| 1 | | | | | | |
| 2 | | | | | | "" |
| 3 | | | | | | |
| 4 | | | | | | |
| 5 | | | | | | "" |
| 6 | | | | | | "" |
| 7 | | | | | -- | "" |
| 8 | | | | | | "" |
| 9 | | | | | | "" |
| 10 | | | | | | "" |
| 11 | | | | | | "" |
| 12 | | | | | | "" |
1 2 , 4 7 - .
2 , Excel.
, «» «» (Data — Advanced ).
« ». , «$A$4:$F$12».
« » «$A$1:$F$2».
:
, . , « ». , , , « » Excel .
, .
« » 4 5 . .
, VBA, , Excel.
VBA, . 2, Excel , , , .
, Excel . , .
.
| | |
| 1 | * | , : |
| 2 | = | , . , , . , . |
| 3 | <> | . |
| 4 | ** | , «»: , . |
| 5 | =????? | , . , . |
, * . «*» , «».
«?» .
OR AND
, , « », (AND). , .
, Excel (OR).
:
| A | B | C | D | E | F |
| 1 | | | | | | |
| 2 | | | | | | |
| 3 | | | | | | |
| 4 | | | | | | |
| 5 | | | | | | |
| 6 | | | | | | "" |
| 7 | | | | | | "" |
| 8 | | | | | -- | "" |
| 9 | | | | | | "" |
| 10 | | | | | | "" |
| 11 | | | | | | "" |
« — — » (Insert — Table — PivotTable ).
, . ( , ) , .
.
, Microsoft Excel . , .
, , Excel, , . , . Microsoft Excel.
, VBA. , .
, , .
. , , .