The attached workbook has three tables. The first two have data computed using formulas while the third table is empty. Calculations in the first table are based on all matches played while calculations in the second table are based on the last five matches.

There is also a drop down menu in cell AT71 with two options i.e. All Matches and Last 5.

REQUIRED:
I want to get rid of the first two tables and have only one table. I would like a situation where when the cell AT71 reads “All Matches, the third table to apply formulas in the first table. And when cell AT71 reads “Last 5”, the third table to pick formulas in the second table. In the end, If I can find a way to achieve this, I will only be having one table (the third one) so I will delete the first two.


EPL.xlsx