I have 6 columns each cell has a value either “Ok” or “Problem”. I
would like to figure out how to automate on column 7 if I have three
“Ok” in my row then type “OK” if I have less than 3 OK in my row then
type “Problem”
A1 B1 C1 D1 E1
F1 G1
1 Ok Ok Problem Problem Problem Problem Problem
2 Ok Problem Ok Ok Problem Ok
Ok