Hi, I have a table like the following : Item Name1 Risk1 Name2 Risk2 Name3 Risk3 item1 bob high bob high margaret low item2 bob high john high lewis high item3 bill low nick very high susan sanction level 1 I'd like to add a column named "Risk Count". The logical test to increment this count is the following : First you have to check is the risk is within the following list ("high","very high","sanction level 1") Second, if you find the risk, you have to check whether the name was already counted or not. Each name assigned to a risk level in the list above must only be counted once per item. What I mean by that, is that in item1 bob is repeated in name1 and name2, but he should just be counted once So the result for each item would be : Item Risk Count item1 1 item2 3 item3 2 Hope you can help me achieve this. Thank you for your help and time.
... View more