=FILTER(RENO[id]]:[renno_yrs],(RENO[chain]=C5)*(RENO[city]=C6) is what i had but it didnt work... pls help!

The focus is Worksheet P5. Author a formula in cell C11 that will display only the records within the RENO table associated with the chosen filter arguments - see cells CS&C6. See the below example: Choose Filter Anuments: selected Chain selected city-? Itat using New York, \& then Pcabody de th If the selected filter argument values change, the data displayed in the results section will automatically update (i.e., the displayed results are dynamic). If the selected filter argument values result in no relevant records, then the following text will be displayed in C11: "no data matches chosen filter arguments". See the below example: Your solution in cell C11 must use the FILTER function. In addition, order the output in ascending order based on the years since the last renovation with the largest years listed first. Use the SORT dynamic array function to control the order of displayed records. Note: if not sure how to use the SORT function, see: httpsi//www automateexcelcom/functions/sort/. Filtering Tabular Data Using Dynamic Array Formulas All formulas and futctions en this workaheet muat feature structured references, where appeopriate. rest using New Yerk, \& then Peabedy