Dear all,
I have a table which is driven by a date selected via a data validation list (of Dates). Is it possible when a user selects a particular date, Excel would automatically compare the sum of three age groups ( 5-10 years, 11-15 years, 16-20 years) in table "Cinema: Age group Attendance" for that date and compare it with similar age groups for the previous week listed in the table.
Once compared, Excel should automatically give me the movement in terms of up, down or no change. (Please see cell f6 in the spreadsheet attached).
Will really appreciate your response.
Thanks in advance.
Bookmarks