Dan_K_2014
Member
Hello All,
I am trying to build a formula to count Unique people names in Column "G" with a multiple conditions. Conditions are:
1. By type in Column "K".
2. By period of time in Column "J".
3. By Location in column "D".
We are looking now at a Analysis sheet.
When I am changing the dates in F7, 8 and G7, 8; and selecting the location name in C4,
In all F and G 12:27 I should have a number of unique (not repeated) names of people from column "G" related to the selected time period and location number.
Thank you.
I am trying to build a formula to count Unique people names in Column "G" with a multiple conditions. Conditions are:
1. By type in Column "K".
2. By period of time in Column "J".
3. By Location in column "D".
We are looking now at a Analysis sheet.
When I am changing the dates in F7, 8 and G7, 8; and selecting the location name in C4,
In all F and G 12:27 I should have a number of unique (not repeated) names of people from column "G" related to the selected time period and location number.
Thank you.