Forum Discussion

madbeatz's avatar
madbeatz
Copper Contributor
Mar 14, 2024

Show distinct value based on multiple conditions

I have a excel data sheet which is an extract from a support tool. The extract is shown in the picture below. Column A - Ticket ID. The ticket ID is unique to each case but appears multiple time as ...
Excel
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    Mar 14, 2024

    Himadbeatz ,
    you can try this formula. This should produce your result:

     

    =IF(AND(E2="L2 Support";OR(F2="Development Team";F2="Product Team");SUMPRODUCT(--(A$2:A2&E$2:E2=A2&E2))=1);1;"")

     

     

dscheikey's avatar
dscheikey
Bronze Contributor
Mar 14, 2024

Himadbeatz ,
you can try this formula. This should produce your result:

 

=IF(AND(E2="L2 Support";OR(F2="Development Team";F2="Product Team");SUMPRODUCT(--(A$2:A2&E$2:E2=A2&E2))=1);1;"")

 

 

  • madbeatz's avatar
    madbeatz
    Copper Contributor
    Mar 18, 2024
    dscheikey Tested against a larger data set and this works! thank you!

Resources