Hi,

Is there a way of putting an if statement in to say that if column C has an answer of ALL then put that answer in column A if column C says anything other than ALL then put it in column B?

Many Thanks for your answers.