Array Formula to count specific text ignoring duplicates.

Hello all,

I am trying to Automize 2 tables in my work book.

Copy of tables attached.

The first table consists of dates members taught specific modules.

Characteristics:

Column A = Date (5 rows are always used for 1 date).
Row 1 = Module name (Upto 30 Modules)
Members are added by drop down menu and can be duplicated in date and/or module.

Requirements:

When table is filled out the Formula would count how many days the specific member was attending. Duplicate enties for a member on the same day will be counted as 1.


Second table consists of Member, Overnight and Total days.

Requirements:

Column "member" is autofilled when a member is added to table 1.
Column "Overnight" is filled by drop down menu.
Column "Total Days" is autofilled in relation to what is chosen in Column "Overnight":
"Yes +1" = Total from Table 1 +1
"Yes" = Total from Table 1
"No" = 0

1. Is this at all possible?
2. What would be used, Formula, Array or Code.
3. Anyone have any ideas how i could accomplish this.

Thanks in advance for any help or ideas anyone can give.