K$28$

Sort & Filter

Data Tools

Analysis $-$ Sheet

$$ Subtotal

Forecast

Outline

Analyze

A

Rank

B

$4$

$\frac{5}{8}$

$7$

$8$

$3$

$10$

$\frac{11}{12}$

$\frac{13}{13}$

$14$

$15$

$15$

$17$

$18$

$19$

$20$

$21$

$23$

$24$

$25$

$26$

$27$

$29$

$30$

$31$

restaurants, based on a recent analysis. In cell J$7,$ use a FILTER function to retrieve all records in the range A$4$:G$28$ that are in the D$.$C$.$ area, with a rank of no higher than $50$ and with an average check of less than $ $100\mathrm{.}00.$ Use the cells in K$1$:K$3$ to reference the criteria.