Need help creating logic to identify multiple values linked to another column

[Hoss2434]

Hello I am trying to create logic that will check if a value from column has a one to many relationship to a value in another column. Here is a before and after example of what I am looking for:

Before:

Customer#	Color
1	red
1	red
2	blue
2	red
3	blue
3	blue

After:

Customer#	Color	Both Colors?
1	red	No
1	red	No
2	blue	Yes
2	red	Yes
3	blue	No
3	blue	No

So in this example we can see that Customer #2 has a record of both "blue" and "red" for it's colors, and there fore the third column marked it "Yes"

If anyone can show me how to create a formula for this that would be greatly appreciated!

Thanks!

[SPetrie]

I think a summarize with count distinct should give you the info you want. Join the result back to the original data set to have it apply to each instance.

[binuacs]

@Hoss2434 One way of doing this

[gaoa]

@Hoss2434