Help updating column value if it has two unique values and if not then leave it alone

[Travis_Ratliff]

Hello people of Earth

Please see below for example of data and how the updated value should look. Basically, what I want to do is if the schedule column has both "OP" and "P" for one price then the schedule should be updated to "FP". Otherwise, do not change the schedule.

Let me know if there are any questions and any help or ideas are appreciated!

Schedule	Price	Updated Schedule
OP	19.17	FP
OP	19.17	FP
P	19.17	FP
P	19.17	FP
OP	22.37	OP
OP	22.37	OP
P	47.25	P
P	47.25	P
P	47.25	P

[JosephSerpis · Accepted solution]

Hi @Travis_Ratliff I came up with one approach using the summarise tool to concatenate the values to find the records that need changing.