Question
Bao wants to identify clients in the southeast with total sales of $100,000 or more, and then list them in a separate part of the worksheet. In cell D6, enter a criterion to select clients in the SE Area. In cell F6, enter a criterion to select Total Sales greater than or equal to 100000. Create an advanced filter using the data in the AccountReps table (range A10:129) as the List range. Use the range A5:16 as the Criteria range. Copy the results to another location, starting in the range A34:134. How to do in excel
Answers
GPT 3.5
To accomplish this task in Excel, follow these steps:
1. In cell D6, enter the criteria "SE" to select clients from the southeast region.
2. In cell F6, enter the criteria ">=100000" to select total sales greater than or equal to $100,000.
3. Select the range A10:129 (the AccountReps table) as the List range.
4. Select the range A5:16 as the Criteria range.
5. Go to the Data tab, click on the Advanced Filter option.
6. In the Advanced Filter dialog box, choose the Copy to another location option.
7. In the Copy to box, enter the range A34:134 as the destination for the filtered results.
8. Make sure that the criteria range and list range fields are filled correctly.
9. Click OK to apply the advanced filter.
10. The filtered results will now be displayed in the range A34:134, listing clients in the southeast with total sales of $100,000 or more.
1. In cell D6, enter the criteria "SE" to select clients from the southeast region.
2. In cell F6, enter the criteria ">=100000" to select total sales greater than or equal to $100,000.
3. Select the range A10:129 (the AccountReps table) as the List range.
4. Select the range A5:16 as the Criteria range.
5. Go to the Data tab, click on the Advanced Filter option.
6. In the Advanced Filter dialog box, choose the Copy to another location option.
7. In the Copy to box, enter the range A34:134 as the destination for the filtered results.
8. Make sure that the criteria range and list range fields are filled correctly.
9. Click OK to apply the advanced filter.
10. The filtered results will now be displayed in the range A34:134, listing clients in the southeast with total sales of $100,000 or more.