fayez_MrExcel
Active Member
- Joined
- Oct 29, 2005
- Messages
- 437
- Office Version
- 365
- Platform
- Windows
Im trying to count a unique value (i.e. the employee no. with 2 criteria: first is the job category (i.e in E3) and the other employee type (i.e. in F3), my below formula is only for criteria. Im trying to put "AND" but the result is wrong. Pls assist to add the second criteria which is employee type (i.e. in F3). Thanks
=SUM(--(FREQUENCY(IF(TC_JobCategory=E3,MATCH(TC_EmpNo,TC_EmpNo,0)),ROW(TC_EmpNo)-ROW(E3)+1)>0))
=SUM(--(FREQUENCY(IF(TC_JobCategory=E3,MATCH(TC_EmpNo,TC_EmpNo,0)),ROW(TC_EmpNo)-ROW(E3)+1)>0))