Something like this ? (I didn't type in the entire ID# )

I did this:

if {fixed [ID] : count(if [Category] = "SCRAP" then 1 end)} = 1

then "REMOVE"

else "KEEP"

end

Can you provide screenshots or something to show what you've done ?

I've shown that it works, so it must be something in your workbook that isn't working properly.

I believe if you modify the calc provided by Chris McClellan slightly, it should work.

if {fixed [ID] : SUM(if [Category] = "SCRAP" then 1 else 0 end)} = 1

then "REMOVE"

else "KEEP"

end

Why does my calculation NOT work though ?  Yes, you can SUM a 1 or 0, that will work perfectly BUT COUNTing the 1's will also work - the screenshot shows that it works.

I apologize, I didn't mean to imply it won't work. I could have definitely worded my response better.