Hello,
I am trying to figure out how to count unique values in column C (session) based on 3 conditions.
<tbody>
</tbody>
Unique value count --> Session
Condition 1 --> Course (Writing Skills)
Condition 2 --> Status (Completed)
Condition 3 --> Date range (May 1 - December 31, 2018)
Thus, I am trying to calculate how many total sessions (not counting duplicates) were held for Writing Skills that were completed from May 1 - December 31, 2018. In this case, it should be a total of 2 sessions during this date range.
I've been trying to figure this out for a while without success. Your assistance is greatly appreciated!
I am trying to figure out how to count unique values in column C (session) based on 3 conditions.
Name | Course | Session | Status | Date |
John | Writing Skills | Writing Skills - May 9 | Completed | 09/05/2018 |
Kelly | Writing Skills | Writing Skills - May 9 | Completed | 09/05/2018 |
Steve | Writing Skills | Writing Skills - Nov 11 | Incomplete | 01/11/2018 |
Stacey | Writing Skills | Writing Skills - Nov 11 | Completed | 01/11/2018 |
Kate | Writing Skills | Writing Skills - Nov 11 | Incomplete | 01/11/2018 |
Mary | Presentation Skills | Presentation Skills - July 26 | Completed | 26/07/2018 |
<tbody>
</tbody>
Unique value count --> Session
Condition 1 --> Course (Writing Skills)
Condition 2 --> Status (Completed)
Condition 3 --> Date range (May 1 - December 31, 2018)
Thus, I am trying to calculate how many total sessions (not counting duplicates) were held for Writing Skills that were completed from May 1 - December 31, 2018. In this case, it should be a total of 2 sessions during this date range.
I've been trying to figure this out for a while without success. Your assistance is greatly appreciated!