Forum Discussion

Vijayvr's avatar
Vijayvr
Copper Contributor
Mar 03, 2024

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 with this combination the entries are . For example : A2 employee has AZ-500 certification in two different dates so i need 2 should reflect in E2 & E3. Like wise for other employees also it should look for combination and get the no of times non column E.

 

Attached sheet has one example.

excel
office 365

3 Replies

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Mar 03, 2024

    Vijayvr 

    Your values would be returned by

    = COUNTIFS(empID, empID, course, course)

    The existence of a repeated certification date would be identified by

    = COUNTIFS(empID, empID, course,  course, date, date) - 1

    I am not sure I fully understand what you would like to display as results.

    • Vijayvr's avatar
      Vijayvr
      Copper Contributor
      Mar 03, 2024
      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

Resources