Bloozntooz
New Member
- Joined
- May 20, 2023
- Messages
- 9
- Office Version
- 2019
- Platform
- Windows
Office 2019 / Windows 10
I have searched numerous websites for a solution to this, but only found ones that partially do what I need. I must apologize for not being able to post a mini-spreadsheet due to limitations on my company PC.
I have a list of names in a column with a corresponding binary number in the next column which indicates if training has been completed.
The names may appear twice, and the 1's may appear once (but in either of the rows for that name), or twice (in both rows).
A very simplified representation is below.
As part of a much larger SUMPRODUCT formula, I am after a formula to count the values of duplicate names only once.
Names Training completed
Andrew 1
George 1
George 1
Simon 0
Simon 1
David 1
David 0
Total should be: 4
Thank you.
I have searched numerous websites for a solution to this, but only found ones that partially do what I need. I must apologize for not being able to post a mini-spreadsheet due to limitations on my company PC.
I have a list of names in a column with a corresponding binary number in the next column which indicates if training has been completed.
The names may appear twice, and the 1's may appear once (but in either of the rows for that name), or twice (in both rows).
A very simplified representation is below.
As part of a much larger SUMPRODUCT formula, I am after a formula to count the values of duplicate names only once.
Names Training completed
Andrew 1
George 1
George 1
Simon 0
Simon 1
David 1
David 0
Total should be: 4
Thank you.