Graham C1600
Board Regular
- Joined
- Feb 17, 2018
- Messages
- 96
- Office Version
- 365
a | b | c | d | e | |
1 | User ID | Login | UTC | Users | |
2 | 1 | Yes | No | 1 | |
3 | 1 | Yes | No | 1 | |
4 | 1 | No | No | 1 | |
5 | 2 | No | Yes | 1 | |
6 | 3 | Yes | Yes | 1 | |
7 | 4 | Yes | No | 1 | |
8 | 4 | No | No | 1 | |
9 | 5 | No | No | 1 |
<tbody>
</tbody>
What I need to try and work out is as follows as a formula for Column D is a follows :-
Colums C is to ="No" Login is to Equal "No" How many unique values are left in Column A ?? So in this example the answer would be 1 and this is user ID 5. This is because there are some Login "Yes" answers for the user ID's. So if anybody has logged in under the User ID I do not want to count that User ID. Just UTC "No" and Logon "No" per User ID.
Secondly I need to count all users in Column D where at least 1 User ID has logged on. So this would be C="No" B="Yes". In this case the answer would be 5. User ID is a No, No and 2 and 3 are a UTC Yes. So if a User ID had a list of 20 underneath and at least one had logged on, I would count them all. I need to exclude any Use ID's where there have been no logon's.
Hope this makes sense.
Thanks