Hi All,
Kindly find the attached file in which I need formula to count data based on Account.
The attached sheet will self-explain the exact requirement.
Your help in this regards will be highly appreciated.
<tbody>
</tbody>
Regards,
Vikkhe1
Kindly find the attached file in which I need formula to count data based on Account.
The attached sheet will self-explain the exact requirement.
Your help in this regards will be highly appreciated.
Desk Location | Emp. ID | Employee Name | Account | ||||
P4001 | #N/A | #N/A | Administration | Account | Employee Count | #N/A Count | |
P4002 | 123 | ABC | Administration | Administration | 4 | 2 | |
P4003 | 345 | BCA | Procurment | Procurment | 3 | 0 | |
P4004 | 567 | CAB | Procurment | Finance | 2 | 1 | |
P4005 | 890 | CAD | Procurment | HR | 1 | 3 | |
P4006 | 1234 | CAF | Administration | ||||
P4007 | 1235 | CVF | Administration | ||||
P4008 | #N/A | #N/A | Administration | ||||
P4009 | 1237 | BGM | Finance | ||||
P4010 | #N/A | #N/A | Finance | ||||
P4011 | 1239 | BVM | Finance | ||||
P4012 | 1230 | MVB | HR | ||||
P4013 | #N/A | #N/A | HR | ||||
P4014 | #N/A | #N/A | HR | ||||
P4015 | #N/A | #N/A | HR | ||||
P4024 | 1244 | VNK | Administration |
<tbody>
</tbody>
Regards,
Vikkhe1