Need a Formula that will count the duplicate values only once relating to unique ID number and show it only once

[Leicester City Fox]

Hi All

Good Morning

Need a Formula that will count the duplicate values only once relating to unique ID number and show it only once

I am looking for a Formula which will only show the Indicator (Column B) once in there are duplicates values of if there are no duplicates just show result in Column C for each User ID (Column A).

I only want it to count the indicator once looking for result of the formula in Column C if it relevant to the specific User id.

A	B	C
User ID	Indicator	Result Wanted ( Formula needed)
A123	Happy	Happy
A123	Happy
A123	Sad	Sad
B234	Good	Good
B234	Good
C345	Fair	Fair
C345	Good	Good
C345	Fair

Many Thanks for you ideas

The Leicester Fox

 

[Fluff]

My Apologies I thought I already updated my account , I have done so and saved it this time.

Many thanks for that.
How about
=IF(AND(MAXIFS(C:C,A:A,A2,B:B,B2)=C2,COUNTIFS(A$2:A2,A2,B$2:B2,B2,C$2:C2,C2)=1),B2,"")