Many ways to handle this. Writing one formula like @txnelson suggested, or you could include a few more steps and have a bit simpler formula with extra step
1. Recode Column 2 in such a way that Good is 0 and Outlier 1 (can use JMPs Recode for this), make sure new column is numeric
![jthi_0-1648617375012.png jthi_0-1648617375012.png](https://community.jmp.com/t5/image/serverpage/image-id/41285i4A5445CA551A369A/image-size/medium?v=v2&px=400)
2. Use formula which will calculate sum (or max value) of the data in the new column (this could be also done with Summary and join or many other ways)
If(ColSum(:"Column 22"n, :"Column 1"n) >= 1,
"Outlier",
"Good"
)
![jthi_1-1648617408616.png jthi_1-1648617408616.png](https://community.jmp.com/t5/image/serverpage/image-id/41286i523044123AEC7782/image-size/medium?v=v2&px=400)
3. Then depending on what you want to do with your data, you could remove duplicates or just the values. Select columns Column 1 and Column 3 and then use JMPs select duplicate rows
![jthi_2-1648617467404.png jthi_2-1648617467404.png](https://community.jmp.com/t5/image/serverpage/image-id/41287i4C0A2F64931EB742/image-size/medium?v=v2&px=400)
4. From here you could delete the rows
![jthi_3-1648617493906.png jthi_3-1648617493906.png](https://community.jmp.com/t5/image/serverpage/image-id/41288i77DF857327508866/image-size/medium?v=v2&px=400)
5. Or if you want to keep the duplicated values but just clear the Column 3 values. While holding alt press on Column3 header so you have only Column3 selected
![jthi_4-1648617616183.png jthi_4-1648617616183.png](https://community.jmp.com/t5/image/serverpage/image-id/41289iF0AFC427F717DBE7/image-size/medium?v=v2&px=400)
and press delete
![jthi_5-1648617637796.png jthi_5-1648617637796.png](https://community.jmp.com/t5/image/serverpage/image-id/41290iDE19D9D3B99C7F02/image-size/medium?v=v2&px=400)
-Jarmo