conditional replacing data in multiple cells

[Downton]

Hi

New and learning so sorry if this is too easy 🙂

I have a set of data and one column marks whether or not a record is confidential.

I want to release most of the data but for rows marked confidential I want to overwrite some cells in that row with the text "withheld".

Any advice on best tool or formulae very welcome.

Cheers

David

[Emil_Kos · Accepted solution]

Hi @Downton,

I have created a dummy data set to help you with your problem. I hope this should give you an idea of how to make it work:

[Downton]

Thanks that's so fantastic took me way longer to understand than it took you to compile 🙂 really helping me reshape my logic