Help with unique value

[leadsmith]

[TABLE="width: 30"]
<tbody>[TR]
[TD]Employee#[/TD]
[TD]ColumnA[/TD]
[TD]ColumnB[/TD]
[/TR]
[TR]
[TD]14900[/TD]
[TD]support[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14900[/TD]
[TD][/TD]
[TD]communication[/TD]
[/TR]
[TR]
[TD]14900[/TD]
[TD][/TD]
[TD]communication[/TD]
[/TR]
[TR]
[TD]15038[/TD]
[TD]support[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15038[/TD]
[TD][/TD]
[TD]communication[/TD]
[/TR]
[TR]
[TD]15039[/TD]
[TD]support[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15062[/TD]
[TD]support[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15062[/TD]
[TD]support[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15062[/TD]
[TD][/TD]
[TD]communication[/TD]
[/TR]
</tbody>[/TABLE]

I need help creating a formula that will get the unique value of employees that has support and communication together. I already figured the formula for calculating how many employees did support alone and communication alone. I'm just having trouble getting the unique value with both. All help will be greatly appreciated.

Then is there a formula to calculate how many communication that each employee did

Thank you

 

[Captain_Conman]

Try this in D2...

=IF(A2=A3,IF(B2="support",IF(C3="communication",A2,""),""),"")