I have an instruction to use an advanced filter (in Excel). Basicall, it says to filter those in Northeast region where the year is 2022 and the sales in that year is greater than 3000 and the year is 2023 where the sales in that year is greater than 2500.
My instructor says to use commas for each. The instructions goes “Filter the data for the following criteria: ‘Northeast’ region, sales in 2022 and 2023 that were greater than 3,000 and 2,500 respectively (use commas for each).”
Currently, I used two rows to do the criteria range (below) and it works perfectly fine:
| Region | Year | Sales |
|---|---|---|
| Northeast | 2022 | >3000 |
| Northeast | 2023 | >2500 |
Kharlo Evangelista is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.