2. If you want to inquire about the customer information with a monthly purchase volume of more than 400 tons and an "excellent" credit rating, then:
1) Establish the conditional zone I1:J3.
2) Select A3:F24, "Data/Filtering/Advanced Filtering/Copying Filtering Results to Other Locations/Conditional Areas I1:J3/Copying to /H5/ OK", and the results will be like yellow areas.
3. If you want to query all customer information with "poor" credit rating, then:
1) Establish the conditional area L 1:L2.
2) Select A3:F24, "Data/Filter/Advanced Filter/Copy the filter result to other locations/condition areas L 1:L2/ Copy to/h1/OK", and the result looks like a green area.
The above are only hypothetical examples, so please draw inferences from others and use them flexibly.
★ After the data table is established, the function of "Data/Record Table" can be enabled to add, delete, modify and query the conditions of file customers. The disadvantage is that the inquired information cannot be printed. For details, please refer to "Use of Record Tables in Excel" in /info/ZTC- 1 152. shtml。