Hello experts,

I have a table in range B11:J1010
Column E11:E1010 indicate date in each row.
Cells E1 and F1 are a dropdown and set by the user.

I need a help doing the following:
If E1="Annual" then show all the rows in range B11:J1010.
If E1="Monthly" then show ONLY the rows that contain the month as appear in Cell F1 (F1 indicate month and set by the user).

The check, whether a row fit or not fit to the selected month, can be applied by using MONTH function:
MONTH($F$1)-MONTH(E11)
MONTH($F$1)-MONTH(E12)
...
MONTH($F$1)-MONTH(E1010)

The condition:
If the result is zero show this row.
If the result is any number other than zero hide the row.

When the user set F1 to another month the rows display in the table need to be updated accordingly of course.
When the user set E1 to Annual all rows should be re-displayed and so on.

I looked over some threads looking for an answer but unfortunately none of them gave me the answer.
Any help to implement this will be greatly appreciated.

Thanks in advance
Kfir