Filter Adv Criteria
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Filter Adv Criteria as PDF for free.
More details
- Words: 427
- Pages: 4
Date Customer 1/1/2002 MegaMart 1/3/2002 MiniMart 1/3/2002 SuperMart 1/3/2002 FoodMart 1/4/2002 MegaMart 1/11/2002 FoodMart 1/11/2002 MegaMart 1/18/2002 MiniMart 1/20/2002 MegaMart 1/20/2002 MegaMart 1/21/2002 MegaMart 1/21/2002 FoodMart 1/25/2002 MegaMart 1/25/2002 MiniMart 1/26/2002 MiniMart 1/26/2002 MiniMart 2/3/2002 SuperMart 2/3/2002 MiniMart 2/4/2002 MiniMart 2/7/2002 MiniMart 2/8/2002 MiniMart 2/17/2002 MegaMart 2/17/2002 MiniMart 2/22/2002 MegaMart 2/23/2002 MiniMart 2/23/2002 MegaMart 2/28/2002 MegaMart
Product Cookies Bread Produce Produce Cookies Produce Produce Produce Cookies Milk Bread Produce Cookies Milk Milk Produce Cookies Milk Milk Cookies Milk Bread Milk Bread Cookies Milk Cookies
Total $278.07 $789.00 $1,365.35 $240.17 $1,348.49 $2,023.35 $292.81 $1,802.92 $1,668.42 $566.00 $422.00 $1,335.74 $176.41 $870.48 $1,682.37 $1,704.22 $460.00 $1,607.04 $1,205.28 $2,191.67 $454.77 $1,800.00 $2,206.89 $122.15 $2,374.06 $1,347.57 $615.94
Total >500
Date >=1/11/02
Use this criteria range to find Items with Total >500
Date <=1/25/02
Use this criteria range to find Items within the date range shown
Note: If you want to extract the results of an Advanced Filter o sheet (e.g. Sheet2):
1. Go to Sheet 2, and select a cell in an unused part of 2. Choose Data>Filter>Advanced Filter. 3. Choose Copy to another location 4. Click in the List Range 5. Select Sheet 1, and select the data list. 6. Click in the Criteria range box. 7. Select the criteria range 8. Click in the Copy to box. 9. Select the cell on Sheet 2 in which you want the resu 10. Click OK
FALSE Use this criteria range to find Items with Total above average: The formula used is: =D2>AVERAGE($D$2:$D$28)
results of an Advanced Filter onto another
ect a cell in an unused part of the sheet. dvanced Filter. er location
ect the data list. ge box. e x. t 2 in which you want the results to start.
Note: If you want to extract the results of an Ad sheet (e.g. Sheet2):
1. Go to Sheet 2, and select a cell in an u 2. Choose Data>Filter>Advanced Filter. 3. Choose Copy to another location 4. Click in the List Range 5. Select Sheet 1, and select the data list 6. Click in the Criteria range box. 7. Select the criteria range 8. Click in the Copy to box. 9. Select the cell on Sheet 2 in which you 10. Click OK
extract the results of an Advanced Filter onto another eet2):
t 2, and select a cell in an unused part of the sheet. ta>Filter>Advanced Filter. py to another location List Range et 1, and select the data list. Criteria range box. riteria range Copy to box. ell on Sheet 2 in which you want the results to start.
Product Cookies Bread Produce Produce Cookies Produce Produce Produce Cookies Milk Bread Produce Cookies Milk Milk Produce Cookies Milk Milk Cookies Milk Bread Milk Bread Cookies Milk Cookies
Total $278.07 $789.00 $1,365.35 $240.17 $1,348.49 $2,023.35 $292.81 $1,802.92 $1,668.42 $566.00 $422.00 $1,335.74 $176.41 $870.48 $1,682.37 $1,704.22 $460.00 $1,607.04 $1,205.28 $2,191.67 $454.77 $1,800.00 $2,206.89 $122.15 $2,374.06 $1,347.57 $615.94
Total >500
Date >=1/11/02
Use this criteria range to find Items with Total >500
Date <=1/25/02
Use this criteria range to find Items within the date range shown
Note: If you want to extract the results of an Advanced Filter o sheet (e.g. Sheet2):
1. Go to Sheet 2, and select a cell in an unused part of 2. Choose Data>Filter>Advanced Filter. 3. Choose Copy to another location 4. Click in the List Range 5. Select Sheet 1, and select the data list. 6. Click in the Criteria range box. 7. Select the criteria range 8. Click in the Copy to box. 9. Select the cell on Sheet 2 in which you want the resu 10. Click OK
FALSE Use this criteria range to find Items with Total above average: The formula used is: =D2>AVERAGE($D$2:$D$28)
results of an Advanced Filter onto another
ect a cell in an unused part of the sheet. dvanced Filter. er location
ect the data list. ge box. e x. t 2 in which you want the results to start.
Note: If you want to extract the results of an Ad sheet (e.g. Sheet2):
1. Go to Sheet 2, and select a cell in an u 2. Choose Data>Filter>Advanced Filter. 3. Choose Copy to another location 4. Click in the List Range 5. Select Sheet 1, and select the data list 6. Click in the Criteria range box. 7. Select the criteria range 8. Click in the Copy to box. 9. Select the cell on Sheet 2 in which you 10. Click OK
extract the results of an Advanced Filter onto another eet2):
t 2, and select a cell in an unused part of the sheet. ta>Filter>Advanced Filter. py to another location List Range et 1, and select the data list. Criteria range box. riteria range Copy to box. ell on Sheet 2 in which you want the results to start.
Related Documents
Filter Adv Criteria
November 2019 19
Adv Filter Search Word
November 2019 13
Adv Filter Budget
November 2019 12
Adv Filter City
November 2019 7
Adv Filter Rep Filtered
November 2019 11