Forum Discussion
Need to count same employee how many times he is reflectin
hi Team , I have attached sheet for your reference. I want formula in E2 : E10 and E2 need a formula to look for A2 employee id with C2 course across the table and should get how many times w...
Hi Peter
Thanks for your response.
I hope this will make you clear.
in cell E2 i need a formula . The formula should look for each employee in A2 : A10 with respective course in column C , If a sample employee has same course multiple times in the excel table it should count and get that count in E2 : E10.
Example : Employee 510931 has same AZ-500 certification two times with different dates so in E2 and E3 it should say 2 as count
Thanks for your response.
I hope this will make you clear.
in cell E2 i need a formula . The formula should look for each employee in A2 : A10 with respective course in column C , If a sample employee has same course multiple times in the excel table it should count and get that count in E2 : E10.
Example : Employee 510931 has same AZ-500 certification two times with different dates so in E2 and E3 it should say 2 as count
