Nested IF Statement

[stephenw1978]

I have a data set in excel that includes duplicate entries. In this example it is fruit names.
What I am looking for is a formula that highlights/calls out those results that do not have any duplicate entries. There is always going to be 3 individual entries. I was hoping an if statement would work that would result in either a "Good" result if the entries are different and a "Not Good" for those entries that include a duplicate fruit name.

I have included an image to my data set below and have highlighted those rows/results that should be given a "Good" due to them only having one value of each fruit. Is this possible using an IF/IF(OR statement? I was using the following, but it didn't seem to provide accurate results: =IF(OR(A2=B2,A2=C2,B2=C2),"Not Good","Good")

Thank you

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[stephenw1978]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Thank you, just updated my details. I am currently running on a Mac using Microsoft 365. The version of Excel I have is 16.87.

 

[Fluff]

Thanks for that.
How about

=IF(MAX(COUNTIFS(A2:C2,A2:C2))=1,"Good","Not good")

 

[stephenw1978]

=IF(MAX(COUNTIFS(A2:C2,A2:C2))=1,"Good","Not good")

Fantastic, thank you

 

[Fluff]

You're welcome & thanks for the feedback.