Hi Team,
In advance thanks for your help.
I have a group of four cells Y, Z, AA, and AB that can contain one of 3 values "Completed", "Waiting" or "Not App"
If all four cells = "Completed" or all four cells = "Not App" then in Cell AE say "Validated"
If any of the four cell contain any other...