| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If but with a twist:(
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function - with a twist! | Excel Discussion (Misc queries) | |||
| Sum with a twist | Excel Discussion (Misc queries) | |||
| SaveCopyAs with a twist | Excel Discussion (Misc queries) | |||
| duplicates with a twist | Excel Discussion (Misc queries) | |||
| Vlookup With A Twist | Excel Worksheet Functions | |||
Threaded Mode
